Thread: timezone + DST handling
Hi, I have a CMS where I display the timezone for international meeting dates. I store the dates as follows: startdate | timestamp with timezone timezonename | text This works fine until I hit daylight-savings time when the name of the timezone changes. So, given a "timestamp with timezone" and a base timezone (non-DST), how can I determine if the date is currently in DST? Is it possible to get the name of the new DST timezone? Thanks! -M
"A.M." <amcauley@bluesocket.com> writes: > This works fine until I hit daylight-savings time when the name of > the timezone changes. So, given a "timestamp with timezone" and a > base timezone (non-DST), how can I determine if the date is currently > in DST? Is it possible to get the name of the new DST timezone? If you are running PG 8.2, the data in the pg_timezone_names and pg_timezone_abbrevs views might help you. regards, tom lane