December 2002
Intermediate to advanced
928 pages
85h 29m
English
EXTRACT ({
[YEAR | MONTH | DAY | HOUR | MINUTE | SECOND] |
[TIMEZONE_HOUR | TIMEZONE_MINUTE] |
[TIMEZONE_REGION | TIMEZONE_ABBR] }
FROM {datetime_expr | interval_value_expr} )Extracts the value of the selected datetime field from the specified datetime expression or interval value expression. The field being extracted must be a valid part of the specified expression. New with Oracle9i.