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

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres