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