Ispirer Website Ispirer Capabilities - Sybase Migration Free Trial

Sybase ASE Data Types - TIME

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

Sybase ASE - TIME
Syntax TIME
Data Time data (hours, minutes, seconds and milliseconds)
Range 00:00:00.000 to 23:59:59.999
Storage Size 4 bytes
Version Differences Sybase 12.5.1 and later - TIME date type is available
Standards ANSI SQL

Sybase ASE TIME - Equivalents in Other Databases

Database Data Type and Conversion
Oracle TIMESTAMP(p), 00:00:00:000000000 and 23:59:59:999999999 (nanoseconds accuracy). Contains day part (year, month and day)
SQL Server TIME(p), 00:00:00:0000000 to 23:59:59:9999999 (100 nanoseconds accuracy)
MySQL TIME, -838:59:59 to 838:59:59 (seconds accuracy)
PostgreSQL TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy)
Informix DATETIME HOUR TO FRACTION(5), 00:00:00:00000 to 23:59:59:99999 (10 microseconds accuracy)
HP Neoview TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy)
Ingres TIME(p), 00:00:00 and 24:00:00

Related Data Types in Sybase ASE

Data Types
Datetime DATE DATETIME SMALLDATETIME

All Data Types


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