Syntax documentationdate_function Locate this document in the navigation structure

Syntax Syntax

  1. <date_function>::=
      ADDDATE(<date_or_timestamp_expression>,<expression>)
    | ADD_MONTHS(<date_or_timestamp_expression>,<expression>)
    | DATEDIFF(<date_or_timestamp_expression>,<date_or_timestamp_expression>)
    | DAYNAME(<date_or_timestamp_expression>)
    | DAYOFMONTH(<date_or_timestamp_expression>)
    | DAYOFWEEK(<date_or_timestamp_expression>)
    | DAYOFYEAR(<date_or_timestamp_expression>)
    | MAKEDATE(<expression>,<expression>)
    | MONTHNAME(<date_or_timestamp_expression>)
    | SUBDATE(<date_or_timestamp_expression>,<expression>)
    | WEEKOFYEAR(<date_or_timestamp_expression>)
End of the code.