- publishing free software manuals
 PostgreSQL Reference Manual - Volume 1 - SQL Language Reference by The PostgreSQL Global Development GroupPaperback (6"x9"), 716 pagesISBN 0954612027RRP £32.00 (\$49.95)Sales of this book support the PostgreSQL project! Get a printed copy>>>

#### 6.5.1.2 Times

The time-of-day types are time [ (p) ] without time zone and time [ (p) ] with time zone. Writing just time is equivalent to time without time zone.

Valid input for these types consists of a time of day followed by an optional time zone. (See Table 6-11 and Table 6-12.) If a time zone is specified in the input for time without time zone, it is silently ignored. You can also specify a date but it will be ignored, except when you use a time zone name that involves a daylight-savings rule, such as America/New_York. In this case specifying the date is required in order to determine whether standard or daylight-savings time applies. The appropriate time zone offset is recorded in the time with time zone value.

Table 6-11: Time Input
 Example Description 04:05:06.789 ISO 8601 04:05:06 ISO 8601 04:05 ISO 8601 040506 ISO 8601 04:05 AM same as 04:05; AM does not affect value 04:05 PM same as 16:05; input hour must be \leq12 04:05:06.789-8 ISO 8601 04:05:06-08:00 ISO 8601 04:05-08:00 ISO 8601 040506-08 ISO 8601 04:05:06 PST time zone specified by abbreviation 2003-04-12 04:05:06 America/New_York time zone specified by full name
Table 6-12: Time Zone Input
 Example Description PST Abbreviation (for Pacific Standard Time) America/New_York Full time zone name PST8PDT POSIX-style time zone specification -8:00 ISO-8601 offset for PST -800 ISO-8601 offset for PST -8 ISO-8601 offset for PST zulu Military abbreviation for UTC z Short form of zulu

Refer to section 6.5.3 Time Zones for more information on how to specify time zones.

 ISBN 0954612027 PostgreSQL Reference Manual - Volume 1 - SQL Language Reference See the print edition