DST and time zones

From: brew(at)theMode(dot)com
To: Postgresql Mailing list <pgsql-novice(at)postgresql(dot)org>
Subject: DST and time zones
Date: 2004-09-18 18:49:35
Message-ID: Pine.BSF.4.58.0409181446030.39269@themode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)theMode(dot)com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
==========================================================================

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message M. Bastin 2004-09-18 19:37:39 Re: Importing data into postgreSQL from FileMaker?
Previous Message A Gilmore 2004-09-18 17:36:31 DST and time zones