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

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres