From: Raman <ramang@smartdatainc.com>
To: pgsql-sql@postgresql.org
Subject: Date format issue
Date: Thu, 18 Mar 2004 11:07:25 +0530
Message-ID: <006301c40cab$1cfbee30$d4c7a8c0@raman> (raw)
References: <E7E213858379814A9AE48CA6754F5ECB0D749E@mail01.stbernard.com>
<200403170927.50757.dev@archonet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ramang@smartdatainc.com
Subject: Re: Date format issue
In-Reply-To: <006301c40cab$1cfbee30$d4c7a8c0@raman>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox