Re: [SQL] Date format issue

2004-03-18 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > You didn't say what version you're using, but IIRC, there was a bug which > caused the above sort of behavior. I think it was fixed in 7.4 and could > be fixed in 7.3.x with a catalog change which you might be able to find in > the archives. Good memory

Re: [SQL] Date format issue

2004-03-17 Thread Stephan Szabo
On Thu, 18 Mar 2004, Raman wrote: > In my query of time zone i have details of interval with me like '-9:00', > '+5:30' etc > > my problem is regarding the format of Date which i receive... ie. when I add > the interval field the results are like: > Query: > select current_date at TIME ZONE "inter

[SQL] Date format issue

2004-03-17 Thread Raman
Hello All... In my query of time zone i have details of interval with me like '-9:00', '+5:30' etc my problem is regarding the format of Date which i receive... ie. when I add the interval field the results are like: Query: select current_date at TIME ZONE "interval" '+5:30'; timezone