Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

Informix Dynamic Server (IDS) Data Types - DATE

Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x

Informix - DATE
Syntax DATE
Data Date data (year, month and day)
Range January 01, 0001 to December 31, 9999
Standards ANSI SQL

Example:

CREATE TABLE t_date (c1 DATE);

Informix 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
PostgreSQL DATE, January 01, 4713 BC to December 31, 5874897
Sybase ASE 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 Informix

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

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