Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

sqlways/postgresql/data-types/time.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement