SQLWays Product Page - Migration to PostgreSQL
Free Evaluation
Versions: PostgreSQL 8.x and 7.x
| PostgreSQL - TIME | |
|---|---|
| Syntax | TIME[(p)] [WITH|WITHOUT TIMEZONE] |
| Data | Time data (hours, minutes, seconds and microseconds) |
| Parameters | p is the number of digits in the fractional part of second, 0 ⇐ p ⇐ 6; WITH TIME ZONE specifies that the time zone is stored along with the time values |
| Default | p is 6 |
| Range | 12:00:00.000000 AM to 11:59:59.999999 PM (00:00:00:000000 and 23:59:59:999999) |
| Special Values | The special value (string in single quotes) is supported: 'now' (current transaction's start time) |
| Storage Size | 8 bytes WITHOUT TIMEZONE and 12 bytes WITH TIMEZONE |
| Standards | ANSI SQL |
PostgreSQL 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) |
| 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) |
| HP Neoview | TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy) |
Related Data Types in PostgreSQL
| Data Types | ||
|---|---|---|
| Datetime | DATE | TIMESTAMP(p) |
| Intervals | INTERVAL(p) | |
All Data Types
| Oracle | SQL Server | IBM DB2 | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird |
SQLWays Product Page - Migration to PostgreSQL
Free Evaluation
Discussion