Thread

RE: [HACKERS] [OT] Timezones and Daylight savings.

Jackson, DeJuan <djackson@cpsgroup.com> — 1999-03-31T21:33:13Z

Here's my problem I need to display times from a Web application for a
specific timezone(very variable).  What I need to know is when that specific
location switches to Daylight savings and what the new timezone abbreviation
would be, so that I can adjust their input datetimes accordingly as well as
my output datetimes.  i.e. CDT to CST 

> -----Original Message-----
> > Could one of you kinds soul point me to the PostgreSQL code for 
> > determining Timezones and Daylight Savings. 
> 
> backend/utils/adt/{dt.c,nabstime.c}
> 
> > If I can assess the OS's database that would be best.
> 
> Not sure what you mean here. As a guess, you should look at the
> utility "zdump", which will show you the transition times for ST/DST.
> You can set the TZ environment variable (or PGTZ envar when running
> Postgres) to test out different time zones, which is how I can test
> bug reports from other parts of the world.
> 
>                       - Tom