DATE

Syntax: | `string = DATE string = DATE('format')`

The `DATE` function can have one argument or no arguments. If no argument is given, it returns a string which contains the current date with the format `dd/mm/yyyy`. A format argument can be provided, as shown in the table below. The seperator used in the format will be used in the output string.

specifier | displays
`d` | Displays the day as a number without a leading zero (1-31)
`dd` | Displays the day as a number with a leading zero (01-31)
`ddd` | Displays the day as an abbreviation (Sun-Sat)
`dddd` | Displays the day as a full name (Sunday-Saturday)
`m` | Displays the month as a number without a leading zero (1-12)
`mm` | Displays the month as a number with a leading zero (01-12)
`mmm` | Displays the month as an abbreviation (Jan-Dec)
`mmmm` | Displays the month as a full name (January-December)
`yy` | Displays the year as a two-digit number (00-99)
`yyyy` | Displays the year as a four-digit number (0000-9999)

Examples

function | result
`DATE` | 23/05/2002
`DATE('mmmm d yyyy')` | May 23 2002
`DATE('dd-mm-yy')` | 23-05-02