< DATE: Getting Literal Data Type   (Previous) Table of Contents (Next)   BOOLEAN: Column Types & Output >

DATE: Supported Ranges

Database Minimum Maximum Notes
Access 2000 1753-01-01 9999-12-31
DB2 8.1 0001-01-01 9999-12-31
Firebird 1.5 0100-01-01

tested 0001-01-01

32768-02-29

tested 9999-12-31

FrontBase 4.1 1600-01-01 9999-12-31
MySQL 4.0 – 4.1 1000-01-01

tested 0001-01-01

9999-12-31
Oracle 9.2 -4712-01-01 4712-12-31

tested 9999-12-31

PostgreSQL 7.4 4713-01-01 BC

tested 4801-03-01 BC

32767-12-31

tested 11754179-08-04

SQL Server 2000 1753-01-01 9999-12-31
SQLite 2.8 any any
Sybase ASE 12.5 1753-01-01 9999-12-31