Postgres Pro
Downloads
Home   >   mailing lists

Re: Timestamp to time_t - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Timestamp to time_t
Date
Msg-id 14201.1253035044@sss.pgh.pa.us
Whole thread Raw
In response to Re: Timestamp to time_t  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Timestamp to time_t
List pgsql-hackers
Tree view 
"David E. Wheeler" <david@kineticode.com> writes:
> On Sep 15, 2009, at 8:50 AM, Tom Lane wrote:
>> See TIMEZONE_HOUR, TIMEZONE_MINUTE field specifications, in particular

> try=# select extract(timezone_hour from '2001-02-16 20:38:40 America/ 
> Los_Angeles'::timestamptz);

You appear to be confusing what PG currently does with what the spec
says.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP: generalized index constraints
Next
From: "Kevin Grittner"
Date:
Subject: Re: hardware information