DST and time zones - Mailing list pgsql-novice

From brew@theMode.com
Subject DST and time zones
Date
Msg-id Pine.BSF.4.58.0409181446030.39269@themode.com
Whole thread Raw
In response to DST and time zones  (A Gilmore <agilmore@shaw.ca>)
List pgsql-novice
A Gilmore......

> Of course this is wrong since DST is in affect, so it should be 'pdt'
> not 'pst'.  I understand that postgresql doesn't do this itself, it uses
> the OS, however does anyone know a crafty way to get the current time in
> any timezone, whether DST is in effect or not?

I think Debian Linux and FreeBSD have a chose of EST or ESTEDT, the later
gives EDT if it is in effect.  Probably the same thing exists for most
timezones (or at least ones that have areas that may or may not observe
DT.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
     Check out my Musician's Online Database Exchange (The MODE Pages)
                        http://www.TheMode.com
 ==========================================================================


pgsql-novice by date:

Previous
From: A Gilmore
Date:
Subject: DST and time zones
Next
From: "M. Bastin"
Date:
Subject: Re: Importing data into postgreSQL from FileMaker?