Re: [GENERAL] timestamps in Australia

2010-11-03 Thread Tom Lane
Jasen Betts writes: > set timezone to 'Australia/Sydney'; > set timezone_abbreviations to 'Australia'; > set datestyle to 'SQL,DMY'; > select '2011-04-03 > 01:00'::timestamptz+generate_series(0,3)*'1h'::interval,generate_series(0,3); > notice how the middle two look the same. > (this is Austra

[GENERAL] timestamps in Australia

2010-11-02 Thread Jasen Betts
set timezone to 'Australia/Sydney'; set timezone_abbreviations to 'Australia'; set datestyle to 'SQL,DMY'; select '2011-04-03 01:00'::timestamptz+generate_series(0,3)*'1h'::interval,generate_series(0,3); notice how the middle two look the same. (this is Australias DST change-back) This has th