Date format issue - Mailing list pgsql-sql

From Raman
Subject Date format issue
Date
Msg-id 006301c40cab$1cfbee30$d4c7a8c0@raman
Whole thread Raw
In response to Line length in pl/pgsql function  ("David Olbersen" <DOlbersen@stbernard.com>)
Responses Re: Date format issue
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "David Olbersen"
Date:
Subject: Re: Line length in pl/pgsql function
Next
From: Stephan Szabo
Date:
Subject: Re: Date format issue