Re: [GENERAL] dst question

2010-03-11 Thread jgirvin
Hi Tom, thanks for the response. Tom Lane wrote: jgirvin writes: Australia will come out of DST on the 4th April 2010 at 03:00:00 and will be +9:30 from utc, currently we are +10:30 utc. OK, so this is a "fall back" transition for you guys, right? Yes this is correct Adelaide, So

Re: [GENERAL] dst question

2010-03-10 Thread Tom Lane
jgirvin writes: > Australia will come out of DST on the 4th April 2010 at 03:00:00 and > will be +9:30 from utc, currently we are +10:30 utc. OK, so this is a "fall back" transition for you guys, right? > This is 4 seconds into the last hour prior to dst changeover, now the > to_timestamp res

[GENERAL] dst question

2010-03-10 Thread jgirvin
Hi, Australia will come out of DST on the 4th April 2010 at 03:00:00 and will be +9:30 from utc, currently we are +10:30 utc. I have some plpgsql functions which have variables of type timestamp defined with time zone. These variables are used in various ways, sometimes they will receive a tex