DATE

Consists of a month, day, and year.

Syntax

DATE

Parameters/Limits

Low Value

High Value

Resolution 

~ 25e+15 BC
 
~ 25e+15 AD
 
1 DAY

See SET DATESTYLE for information about ordering.

'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.

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