Re: Money casting too liberal?
От | Chris Angelico |
---|---|
Тема | Re: Money casting too liberal? |
Дата | |
Msg-id | CAPTjJmp72fbxWed=JcQ1aZyeyCtAP9Wnn3VbmDp-OVKvvZo8Jw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Money casting too liberal? (Jasen Betts <jasen@xnet.co.nz>) |
Ответы |
Re: Money casting too liberal?
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: