Syntax documentationdate_function Locate this document in the navigation structure

Syntax Syntax

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