DATE

Consists of a month, day, and year.

Consists of a month, day, and year. The following limits apply:

Lowest value: ~ 25e+15 BC
Higest value: ~ 25e+15 AD
Resolution: 1 DAY

See SET DATESTYLE for information about ordering.

Note

'0000-00-00' is not valid. If you try to insert that value into a DATE or TIMESTAMP field, an error occurs. If you copy '0000-00-00' into a DATE or TIMESTAMP field, Vertica converts the value to 0001-01-01 00:00:00 BC.

Syntax

DATE

Examples

Example	Description
`January 8, 1999`	Unambiguous in any `datestyle` input mode
`1999-01-08`	ISO 8601; January 8 in any mode (recommended format)
`1/8/1999`	January 8 in `MDY` mode; August 1 in `DMY` mode
`1/18/1999`	January 18 in `MDY` mode; rejected in other modes
`01/02/03`	January 2, 2003 in `MDY` mode February 1, 2003 in `DMY` mode February 3, 2001 in `YMD` mode
`1999-Jan-08`	January 8 in any mode
`Jan-08-1999`	January 8 in any mode
`08-Jan-1999`	January 8 in any mode
`99-Jan-08`	January 8 in `YMD` mode, else error
`08-Jan-99`	January 8, except error in `YMD` mode
`Jan-08-99`	January 8, except error in `YMD` mode
`19990108`	ISO 8601; January 8, 1999 in any mode
`990108`	ISO 8601; January 8, 1999 in any mode
`1999.008`	Year and day of year
`J2451187`	Julian day
`January 8, 99 BC`	Year 99 before the Common Era