Syntax documentationextraction_function Locate this document in the navigation structure

Syntax Syntax

  1. <extraction_function> ::=
      YEAR(<date_or_timestamp_expression>)
    | MONTH(<date_or_timestamp_expression>)
    | DAY(<date_or_timestamp_expression>)
    | HOUR(<time_or_timestamp_expression>)
    | MINUTE(<time_or_timestamp_expression>)
    | SECOND(<time_or_timestamp_expression>)
    | MICROSECOND(<expression>)
    | TIMESTAMP(<expression>[,<expression>])
    | DATE(<expression>)
    | TIME(<expression>)
    
End of the code.