[OT] Timezones and Daylight savings.

Lists: pgsql-hackers
From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: PGSQL Hackers <pgsql-hackers(at)hub(dot)org>
Subject: [OT] Timezones and Daylight savings.
Date: 1999-03-31 00:02:21
Message-ID: D05EF808F2DFD211AE4A00105AA1B5D2037C88@cpsmail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Could one of you kinds soul point me to the PostgreSQL code for determining
Timezones and Daylight Savings. If I can assess the OS's database that
would be best. Thanks
-DEJ


From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "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 15:47:04
Message-ID: 37024378.76568813@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> 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