Sybase ASE Data Types - DATETIME

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - DATETIME
Syntax	DATETIME
Data	Date and time data (year, month, day, hours, minutes, seconds and 1/300 seconds)
Range	January 01, 1753 00:00:00.000 to December 31, 9999 23:59:59.997 with accuracy 1/300 second
Storage Size	8 bytes
Standards	Sybase Transact-SQL Extension

Sybase ASE DATETIME - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	TIMESTAMP(p), January 1, 4712 BC 00:00:00.000000000 to December 31, 9999 23:59:59.999999999 (nanoseconds accuracy)
SQL Server	DATETIME, January 01, 1753 00:00:00.000 to December 31, 9999 23:59:59.997 with accuracy 1/300 second DATETIME2 and DATETIMEOFFSET, January 01, 0001 00:00:00.0000000 to December 31, 9999 23:59:59.9999999 (100 nanoseconds accuracy)
MySQL	DATETIME, January 01, 1000 00:00:00 to December 31, 9999 23:59:59 (seconds accuracy)
PostgreSQL	TIMESTAMP(p), January 01, 4713 BC 00:00:00:000000 and December 31, 5874897 23:59:59:999999 (microseconds accuracy)
Informix	DATETIME, January 01, 0001 00:00:00.00000 to December 31, 9999 23:59:59.99999 (with 10 microseconds accuracy )
Teradata	TIMESTAMP(p), January 01, 0001 00:00:00.000 to December 31, 9999 23:59:61.999999 (microseconds accuracy)
HP Neoview	TIMESTAMP(p), January 01, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999 (microseconds accuracy)
Ingres	TIMESTAMP(p), 0001-01-01 00:00:00 to 9999-12-31 24:00:00

Related Data Types in Sybase ASE

Data Types
Datetime	DATE	TIME	SMALLDATETIME

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres