Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

sqlways/postgresql/data-types/date.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement