Re: [SQL] Query TIME ZONE

2004-01-28 Thread Raman Garg
Thanks Tom it worked for me... yes I got it wrong.. thanks for the correction. thanks a lot.. -- Raman - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Raman" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 28,

Re: [SQL] Query TIME ZONE

2004-01-27 Thread Tom Lane
"Raman" <[EMAIL PROTECTED]> writes: > [ okay: ] > "select current_time AT TIME ZONE INTERVAL '+5:30'" > [ not okay: ] > "select current_time AT TIME ZONE INTERVAL time_difference from customer_events" "TIME ZONE INTERVAL" is not a SQL construct. You have misunderstood the interaction of two diffe