Ispirer Website Ispirer Capabilities - Sybase Migration Free Trial

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


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.