PostgreSQL Data Types - DATE

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - DATE
Syntax	DATE
Data	Date data (year, month and day)
Range	January 01, 4713 BC to December 31, 5874897
Special Values	The special values (strings in single quotes) are supported: 'epoch' (1970-01-01 00:00:00 - Unix system time zero), 'now' (current date), 'today', 'yesterday' and 'tomorrow'
Storage Size	4 bytes
Standards	ANSI SQL

PostgreSQL DATE - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	DATE, January 01, 4712 BC to December 31, 9999. Contains time part (hours, minutes and seconds)
SQL Server	DATE, January 01, 0001 to December 31, 9999
MySQL	DATE, January 01, 1000 to December 31, 9999
Sybase ASE	DATE, January 01, 0001 to December 31, 9999
Informix	DATE, January 01, 0001 to December 31, 9999
HP Neoview	DATE, January 01, 0001 to December 31, 9999
Ingres	DATE, 0001-01-01 to 9999-12-31

Related Data Types in PostgreSQL

Data Types
Datetime	TIME(p)	TIMESTAMP(p)
Intervals	INTERVAL(p)

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres