TIMESTAMP: Supported Ranges
| Database | Minimum | Maximum | Notes |
|---|---|---|---|
| Access 2000 | 1753-01-01 00:00:00 | 9999-12-31 23:59:59 | |
| DB2 8.1 | 0001-01-01 00:00:00 | 9999-12-31 23:59:59 | |
| Firebird 1.5 |
0100-01-01 00:00:00
tested 0001-01-01 00:00:00 |
32768-02-29 23:59:59
tested 9999-12-31 23:59:59 |
|
| FrontBase 4.1 | 1600-01-01 00:00:00 | 9999-12-31 23:59:59 | |
| MySQL 4.0 – 4.1 |
1000-01-01 00:00:00
tested 0001-01-01 00:00:00 |
9999-12-31 23:59:59 | |
| Oracle 9.2 | -4712-01-01 00:00:00 |
4712-12-31 23:59:59
tested 9999-12-31 23:59:59 |
|
| PostgreSQL 7.4 |
4713-01-01 00:00:00 BC
tested 4714-11-24 00:00:00 BC |
5874897-12-31 23:59:59 | |
| SQL Server 2000 | 1753-01-01 00:00:00 | 9999-12-31 23:59:59 | |
| SQLite 2.8 | any | any | |
| Sybase ASE 12.5 | 1753-01-01 00:00:00 | 9999-12-31 23:59:59 |