Sybase ASE Data Types - DATE

Versions: Sybase Adaptive Server Enterprise 15.x and 12.5.x

Sybase ASE - DATE
Syntax	DATE
Data	Date data (year, month and day)
Range	January 01, 0001 to December 31, 9999
Storage Size	4 bytes
Version Differences	Sybase 12.5.1 and later - DATE date type is available
Standards	ANSI SQL

Sybase ASE 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
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 Sybase ASE

Data Types
Datetime	TIME	DATETIME	SMALLDATETIME

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres