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,
"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
Hi All,
I have a query regarding Time Zone
Interval
QUERY:
"select current_time AT TIME ZONE INTERVAL '+5:30'"
it is running fine
BUT
When I take the value of interval from DB
table like:
"select current_time AT TIME ZONE INTERVAL
time_difference from customer_events"
here : time_d
