Local SQL supports the EXTRACT( ) function for isolating a single numeric field from a date/time field on retrieval using the following syntax:

EXTRACT (<extract field> FROM <field name>)

where <extract_field> can be one of: YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND.

In local SQL, EXTRACT( ) does not support the TIMEZONE_HOUR or TIMEZONE_MINUTE clauses.