Ispirer Home Page
Ispirer SQLWays Product Page - Migration to Neoview
Request SQLWays
HP Neoview Data Types - TIME
Versions: HP Neoview 2.4, 2.3 and 2.2
HP Neoview - TIME | |
---|---|
Syntax | TIME[(p)] |
Data | Time data (hours, minutes, seconds and fraction of seconds) |
Parameters | p is the number of digits in the fractional part of second, 0 ⇐ p ⇐ 6 (microseconds) |
Default | p is 0 |
Range | 00:00:00:000000 and 23:59:59:999999 |
Storage Size | 7 bytes (3 bytes without fraction) |
Standards | ANSI SQL |
HP Neoview 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 and 23:59:59.9999999 (100 nanoseconds accuracy) |
MySQL | TIME, -838:59:59 to 838:59:59 (seconds accuracy) |
Postgre SQL | TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy) |
Sybase ASE | TIME, 00:00:00:000 and 23:59:59:999 (milliseconds accuracy) |
Informix | DATETIME HOUR TO FRACTION(5), 00:00:00:00000 to 23:59:59:99999 (10 microseconds accuracy) |
Ingres | TIME(p), 00:00:00 and 24:00:00 |
Related Data Types in HP Neoview
Data Types | |||
---|---|---|---|
Datetime | DATE | TIMESTAMP(p) | |
Intervals | INTERVAL year-month | INTERVAL day-time |
All Data Types
Oracle | SQL Server | IBM DB2 | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird | HiRDB | Ingres |
Ispirer Home Page
Ispirer SQLWays Product Page - Migration to Neoview
Request SQLWays