1
Download Manual del usuario de PostgreSQL [ Postgres
Transcript
Capítulo 3. Data Types Example 04:05:06.789 04:05:06 04:05 040506 04:05 AM 04:05 PM z zulu allballs Description ISO-8601 ISO-8601 ISO-8601 ISO-8601 Same as 04:05; AM does not affect value Same as 16:05; input hour must be <= 12 Same as 00:00:00 Same as 00:00:00 Same as 00:00:00 3.4.1.3. timestamp Valid input for the timestamp type consists of a concatenation of a date and a time, followed by an optional AD or BC, followed by an optional time zone. (See below.) Thus 1999-01-08 04:05:06 -8:00 is a valid timestamp value, which is ISO-compliant. In addition, the wide-spread format January 8 04:05:06 1999 PST is supported. Tabla 3-12. PostgreSQL Time Zone Input Time Zone PST -8:00 -800 Description Pacific Standard Time ISO-8601 offset for PST ISO-8601 offset for PST 28
