Received: from myst.fourpalms.org (myst.jpl.nasa.gov [137.78.15.105])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1GKK6x56330
	for <pgsql-docs@postgresql.org>; Fri, 16 Feb 2001 15:20:06 -0500 (EST)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1])
	by myst.fourpalms.org (Postfix) with ESMTP
	id A58AFC6AF; Fri, 16 Feb 2001 19:21:06 +0000 (UTC)
Message-ID: <3A8D7DA2.40794967@alumni.caltech.edu>
Date: Fri, 16 Feb 2001 19:21:06 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
Reply-To: thomas@pgsql.com
Organization: PostgreSQL
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-docs@postgresql.org,
	Thomas Lockhart <lockhart@fourpalms.org>
Subject: Re: Undocumented datetime functions
References: <Pine.LNX.4.30.0102161909170.1009-100000@peter.localdomain>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200102/100
X-Sequence-Number: 358

> 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.

                          - Thomas