From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
Cc: | PGSQL Hackers <pgsql-hackers(at)hub(dot)org> |
Subject: | RE: [HACKERS] [OT] Timezones and Daylight savings. |
Date: | 1999-03-31 21:33:13 |
Message-ID: | D05EF808F2DFD211AE4A00105AA1B5D2037FA3@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-04-01 00:07:08 | Re: [HACKERS] libpq++ |
Previous Message | Oleg Bartunov | 1999-03-31 20:11:08 | problem with view |