Query TIME ZONE

From: "Raman" <ramang(at)smartdatainc(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Query TIME ZONE
Date: 2004-01-28 05:19:37
Message-ID: 003c01c3e55e$54b12d50$d4c7a8c0@raman
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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_difference - is my varchar column in the table customer_events. This gives me errors " parse error at or near "time_difference" at character 43 "

I tried to type cast it time_difference::text etc but it in vain.

Pls help me ... its realy urgent.

Thanks in advance

Raman Garg

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-01-28 05:58:32 Re: Query TIME ZONE
Previous Message Josh Berkus 2004-01-27 23:12:16 Re: postgreSQl 7.4.1 and Hibernate