On Fri, Mar 29, 2013 at 10:39 AM, Jasen Betts <jasen@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