The following bug has been logged online:
Bug reference: 6001
Logged by: Marek Nos
Email address: marek....@centrum.cz
PostgreSQL version: 9.0
Operating system: Windows 7
Description: date_trunc is not timezone aware
Details:
and other like extract() as well
SELECT date_trunc('day', '2011-05-02 02:00:00+05'::timestamptz)
I would expect result as
'2011-05-02 00:00:00+05'
but
'2011-05-01 00:00:00+02' is given (pre conversion to server timezone is done
first)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
