Re: [GENERAL] timezone + DST handling

2007-08-04 Thread Tom Lane
"A.M." <[EMAIL PROTECTED]> 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 n

[GENERAL] timezone + DST handling

2007-08-04 Thread A.M.
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