X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F2B31D1E9B8 for ; Thu, 18 Mar 2004 05:42:43 +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 13797-01 for ; Thu, 18 Mar 2004 01:42:41 -0400 (AST) Received: from smartdatainc.com (unknown [202.164.35.114]) by svr1.postgresql.org (Postfix) with ESMTP id 44EB1D1D549 for ; Thu, 18 Mar 2004 01:42:37 -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 ; Thu, 18 Mar 2004 11:11:54 +0530 Message-ID: <006301c40cab$1cfbee30$d4c7a8c0@raman> From: "Raman" To: References: <200403170927.50757.dev@archonet.com> Subject: Date format issue Date: Thu, 18 Mar 2004 11:07:25 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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-Archive-Number: 200403/191 X-Sequence-Number: 17290 Hello All... In my query of time zone i have details of interval with me like '-9:00', '+5:30' etc my problem is regarding the format of Date which i receive... ie. when I add the interval field the results are like: Query: select current_date at TIME ZONE "interval" '+5:30'; timezone 11399908 years 8 mons 1538 days but instead of interval when i run query like" Query: select current_date at TIME ZONE 'IST' timezone 2004-03-17 20:30:00 I want the format should be like 2004-03-17 20:30:00 How can I do that with INTERVAL information with me?? pls guide me.. Also can I have link to some doucmentation where i can read about Date/Time zone related theroy/functions?? thanks in advance.. regards, Raman Garg