Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group