DATE
Returns a date with the given attributes.
Return Value
Date/Time
Syntax
DATE( year, month, day
)
OR
DATE( year, month, day, hour, minute,
second, millisecond )
where:
- year is a four-digit integer.
- month is a one-digit or two-digit integer (1 through 12).
- day is a one-digit or two-digit integer (1 through 31).
- hour is a one-digit or two-digit integer (0 through 23).
- minute is a one-digit or two-digit integer (0 through 59).
- second is a one-digit or two-digit integer (0through 59).
- millisecond is a one-digit to three-digit integer (0 through 999).
You must use one of the two syntax models; otherwise, the system returns an error.