DATE
Converts a year, month, and day into a date
Usage examples
-
DATE(2010, 1, 1) -
DATE(tableA.fieldB, tableA.fieldC, tableA.fieldD)
Syntax
DATE ( year, month, day )
-
year- the year component of the date -
month- the month component of the date -
day- the day component of the date
Returns
number - the date in days given the year, month, and day.