Ispirer Website
Ispirer Capabilities - Ingress Migration
Free Trial
Ingres Data Types - TIME
Versions: Ingres 9.x and 10.0
| Ingres - TIME | |
|---|---|
| Syntax | TIME[(p)] [WITH|WITH LOCAL|WITHOUT TIME ZONE] |
| Data | Time data (hours, minutes, seconds) |
| Parameters | p indicates the number of digits of precision in the fractions of seconds, as an integer value from 0 to 9 |
| Range | 00:00:00 to 24:00:00 |
| Default | p is 0 |
| Standards | ANSI SQL |
Ingres 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) |
| Sybase ASE | TIME, 00:00:00:000 to 23:59:59:999 (milliseconds 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) |
Related Data Types in Ingres
| Data Types | ||||
|---|---|---|---|---|
| Datetime | DATE | TIMESTAMP(p) | ANSIDATE | INGRESDATE |
| Intervals | INTERVAL | |||
All Data Types