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 |