[OT] Timezones and Daylight savings.

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

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