On Fri, Mar 29, 2013 at 10:39 AM, Jasen Betts <ja...@xnet.co.nz> wrote: > how confusing is 'EST' ? > worse than this: > > set datestyle to 'sql,dmy'; > set time zone 'Australia/Brisbane'; > select '20130101T000000Z'::timestamptz; > set time zone 'Australia/Sydney'; > select '20130101T000000Z'::timestamptz; > set time zone 'America/New_York'; > select '20130101T000000Z'::timestamptz;
As a Melburnian (that is, I live in Australia/Melbourne, which is in the same timezone as Sydney - but not Brisbane), I prefer to call it EAST - Eastern Australian Standard Time. Of course, for anything that really matters, I'll work with UTC. Much safer. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
