This could be off-topic for this list, but it is moderately closely
related...
I've been involved in some discussion that has concluded that the result
of (thinks hard, and crosses fingers that I've done my mental arithmetic
correctly -- if I'm wrong, I meant +08:00 instead):
On Aug 20, 2008, at 21:17, Jonathan Leffler wrote:
SELECT UNIQUE
EXTRACT(HOUR FROM TIMESTAMP '1999-12-31 23:59:59-08:00') AS
ts_hour,
EXTRACT(DAY FROM TIMESTAMP '1999-12-31 23:59:59-08:00') AS
ts_day,
EXTRACT(MONTH FROM TIMESTAMP '1999-12-31 23:59:59-08:00') AS
ts_month,