Re: [SQL] convert timezone to string ...

2005-10-25 Thread Marc G. Fournier
On Tue, 25 Oct 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: I know that the server knows that ADT == -0400, and AST == -0300 ... Other way around isn't it? Unless Canada observes a pretty strange variety of daylight saving time ;-) I knew I was going to get that bac

Re: [SQL] convert timezone to string ...

2005-10-25 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > I know that the server knows that ADT == -0400, and AST == -0300 ... Other way around isn't it? Unless Canada observes a pretty strange variety of daylight saving time ;-) regards, tom lane ---(end

Re: [SQL] convert timezone to string ...

2005-10-25 Thread Magnus Hagander
> I know that the server knows that ADT == -0400, and AST == > -0300 ... is there any way of reversing that? Basically, I > want to say: > > SELECT timezone_str(-0400, 'not dst'); > > and have it return ADT ... I've got a method of doing it > right now, using a function, but just find it look