Ispirer Ispirer
[Ingres Data Types - DATE]
 
You are here: » Ispirer Migration Knowledge Base » Ingres Database - Migration Reference » Ingres Data Types » Ingres Data Types - DATE


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

Ingres Data Types - DATE

Versions: Ingres 9.x and 10.0

Ingres - DATE
Syntax DATE
Data Date data (year, month and day)
Range 0001-01-01 to 9999-12-31
Storage Size 12 bytes
Standards ANSI SQL

Ingres 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
Informix DATE, January 01, 0001 to December 31, 9999
HP Neoview DATE, January 01, 0001 to December 31, 9999

Related Data Types in Ingres

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

All Data Types

Oracle SQL Server IBM DB2 MySQL PostgreSQL Sybase ASE Sybase ASA Informix DS Teradata HP Neoview Interbase/Firebird HiRDB Ingres


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

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