DATE consists of a month, day, and year. See SET DATESTYLE for information about ordering.
Syntax
DATE
Semantics
Low Value |
High Value |
Resolution |
4713 BC |
32767 AD |
1 DAY |
Example |
Description |
January 8, 1999 |
unambiguous in any |
1999-01-08 |
ISO 8601; January 8 in any mode (recommended format) |
1/8/1999 |
January 8 in |
1/18/1999 |
January 18 in |
01/02/03 |
January 2, 2003 in |
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 |
08-Jan-99 |
January 8, except error in |
Jan-08-99 |
January 8, except error in |
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 |