timezone + DST handling - Mailing list pgsql-general

From A.M.
Subject timezone + DST handling
Date
Msg-id 59B30446-724D-4626-989F-A72196F7133E@bluesocket.com
Whole thread Raw
Responses Re: timezone + DST handling  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: pg_shdepend big
Next
From: "Gavin M. Roy"
Date:
Subject: Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)?