Syntax: |
string = DATE
|
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 |