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
Esteban Gutierrez Abarzua writes:
> I need to know.. How can I get running query time ?
time psql -c 'query here;'
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 6: Have you searche
Hi I am Esteban from Chile!
I need to know.. How can I get running query time ?
I mean . is there any function?
I hope the answer in english or spanish?
thanks!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
ht
