X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EA548D1D461 for ; Wed, 28 Jan 2004 05:23:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18044-10 for ; Wed, 28 Jan 2004 01:23:28 -0400 (AST) Received: from smartdatainc.com (unknown [203.129.220.82]) by svr1.postgresql.org (Postfix) with ESMTP id 00545D1CCA2 for ; Wed, 28 Jan 2004 01:23:25 -0400 (AST) Received: from raman ([192.168.199.212]) by smartdatainc.com ([192.168.199.92]) with SMTP (MDaemon.PRO.v6.5.2.R) for ; Wed, 28 Jan 2004 10:52:36 +0530 Message-ID: <003c01c3e55e$54b12d50$d4c7a8c0@raman> From: "Raman" To: Subject: Query TIME ZONE Date: Wed, 28 Jan 2004 10:49:37 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0039_01C3E58C.6C5110A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-MDRemoteIP: 192.168.199.212 X-Return-Path: ramang@smartdatainc.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_FONT_COLOR_RED X-Spam-Level: X-Archive-Number: 200401/227 X-Sequence-Number: 16620 This is a multi-part message in MIME format. ------=_NextPart_000_0039_01C3E58C.6C5110A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I have a query regarding Time Zone Interval QUERY: "select current_time AT TIME ZONE INTERVAL '+5:30'"=20 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_ev= ents" here : time_difference - is my varchar column in the table customer_events.= This gives me errors " parse error at or near "time_difference" at charact= er 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 ------=_NextPart_000_0039_01C3E58C.6C5110A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi All,

I have a query regarding Time Zone=20 Interval

QUERY:

"select current_time AT TIME ZONE INTERVAL= '+5:30'"=20

it is running fine

BUT

When I take the value of interval fro= m DB=20 table like:

"select current_time AT TIME ZONE INTERVAL= =20 time_difference from customer_events"

here : time_difference - is my varchar column in the table customer_ev= ents.=20 This gives me errors " parse error at or near=20 "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

------=_NextPart_000_0039_01C3E58C.6C5110A0--