| The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group Paperback (6"x9"), 454 pages ISBN 9781906966041 RRP £14.95 ($19.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
6.5.1.1 Dates
Table 6-10 shows some possible
inputs for the date type.
Table 6-10: Date Input
| Example | Description
|
| 1999-01-08 | ISO 8601; January 8 in any mode
(recommended format)
|
| January 8, 1999 | unambiguous in any datestyle input mode
|
| 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 BC |
| ISBN 9781906966041 | The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference | See the print edition |