The EXTRACT() Function

Go Up to Features Available in All Dialects

The new EXTRACT() function extracts information from the new DATE, TIMESTAMP, and TIME data types. In dialect 1, you can use it to extract information from the TIMESTAMP data type.

Note: “DATE” is new in the sense that it has a different meaning in dialect 3 databases than it did previously.