Neoview SQL Reference Manual (R2.4)

EXTRACT Function
The EXTRACT function extracts a datetime field from a datetime or interval value expression.
It returns an exact numeric value.
EXTRACT (datetime-field FROM extract-source)
datetime-field is:
YEAR | MONTH | DAY | HOUR | MINUTE | SECOND
extract-source is:
datetime-expression | interval-expression
See “Datetime Value Expressions” (page 242) and “Interval Value Expressions” (page 246).
Examples of EXTRACT
• Extract the year from a DATE value:
EXTRACT (YEAR FROM DATE '2007-09-28')
The result is 2007.
• Extract the year from an INTERVAL value:
EXTRACT (YEAR FROM INTERVAL '01-09' YEAR TO MONTH)
The result is 1.
EXTRACT Function 383