Ispirer Website
Ispirer Capabilities - PostgreSQL Migration
Free Trial
PostgreSQL Data Types - TIME
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) |
Ingres | TIME(p), 00:00:00 and 24:00:00 |
Related Data Types in PostgreSQL
Data Types | ||
---|---|---|
Datetime | DATE | TIMESTAMP(p) |
Intervals | INTERVAL(p) |
All Data Types