Re: Undocumented datetime functions - Mailing list pgsql-docs

From Tom Lane
Subject Re: Undocumented datetime functions
Date
Msg-id 12574.982346949@sss.pgh.pa.us
Whole thread Raw
In response to Re: Undocumented datetime functions  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-docs
Peter Eisentraut <peter_e@gmx.net> writes:
> I'm confused about tz_hour and tz_minute.

Lockhart would be the authority here, but I think that tz_hour/tz_minute
tell you your timezone in the form of hours & minutes west of GMT.
'timezone' gives the same info in a pure total-minutes-west style.

(There are places that run with standard time a nonintegral number of
hours off GMT, oddly enough, so you do need the minutes part.)

            regards, tom lane

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Undocumented datetime functions
Next
From: "Alethea Boey"
Date:
Subject: missing chapter in documentation