> 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
Strange Brew (brew(at)theMode(dot)com)
Check out my Musician's Online Database Exchange (The MODE Pages)
In response to
pgsql-novice by date
|Next:||From: M. Bastin||Date: 2004-09-18 19:37:39|
|Subject: Re: Importing data into postgreSQL from FileMaker?|
|Previous:||From: A Gilmore||Date: 2004-09-18 17:36:31|
|Subject: DST and time zones|