pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedconvert timezone to string ...
4+ messages / 3 participants
[nested] [flat]
* convert timezone to string ...
@ 2005-10-25 05:42 Marc G. Fournier <scrappy@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Marc G. Fournier @ 2005-10-25 05:42 UTC (permalink / raw)
To: pgsql-sql
I know that the server knows that ADT == -0400, and AST == -0300 ... is
there any way of reversing that? Basically, I want to say:
SELECT timezone_str(-0400, 'not dst');
and have it return ADT ... I've got a method of doing it right now, using
a function, but just find it looks so messy, just wondering if there is a
clean way of doing it ...
Thanks ...
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: convert timezone to string ...
@ 2005-10-25 11:03 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 4+ messages in thread
From: Magnus Hagander @ 2005-10-25 11:03 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; pgsql-sql
> I know that the server knows that ADT == -0400, and AST ==
> -0300 ... is there any way of reversing that? Basically, I
> want to say:
>
> SELECT timezone_str(-0400, 'not dst');
>
> and have it return ADT ... I've got a method of doing it
> right now, using a function, but just find it looks so messy,
> just wondering if there is a clean way of doing it ...
>
> Thanks ...
How would you know *which* timezone to go back to? For every hourly
offset there is a whole set of timezones that would result in it...
//Magnus
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: convert timezone to string ...
@ 2005-10-25 13:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: Marc G. Fournier <scrappy@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2005-10-25 13:19 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-sql
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> I know that the server knows that ADT == -0400, and AST == -0300 ...
Other way around isn't it? Unless Canada observes a pretty strange
variety of daylight saving time ;-)
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: convert timezone to string ...
@ 2005-10-25 15:02 Marc G. Fournier <scrappy@postgresql.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Marc G. Fournier @ 2005-10-25 15:02 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
On Tue, 25 Oct 2005, Tom Lane wrote:
> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> I know that the server knows that ADT == -0400, and AST == -0300 ...
>
> Other way around isn't it? Unless Canada observes a pretty strange
> variety of daylight saving time ;-)
I knew I was going to get that backwards :(
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-10-25 15:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-25 05:42 convert timezone to string ... Marc G. Fournier <scrappy@postgresql.org>
2005-10-25 13:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-10-25 15:02 ` Marc G. Fournier <scrappy@postgresql.org>
2005-10-25 11:03 Re: convert timezone to string ... Magnus Hagander <mha@sollentuna.net>
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