Re: Undocumented datetime functions

Thomas Lockhart writes:

> > I'm confused about tz_hour and tz_minute.  Are the regular 'hour' and
> > 'minute' time zone asensitive?
>
> Regular hour and minute arguments return values interpreted in the
> currently valid time zone, except for types which have no affiliated
> time zone (e.g. "time").
>
> tz_hour and tz_minute return the hour and minutes fields of the current
> time zone, or stored time zone for the timetz type.

Hmm, I'm confused.  The timestamp type doesn't actually have a time zone
stored, does it?  Why did you want it to be dumped as "timestamp with time
zone" then?

Also, it's not possible to cast "time with time zone" to "timestamp", so
it's not possible to make real use of extract(timezone_... ).

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/