Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL Data Types - TIME

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - TIME
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
Intervals INTERVAL(p)

All Data Types

© 1999-2023, Ispirer Systems, LLC. All Rights Reserved.