User Documentation
Ispirer Capabilities - Sybase Migration
Pricing
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