Обсуждение: dst 2007?

Is your database ready for the Daylight Savings Times change of 2007?

http://people.planetpostgresql.org/greg/index.php?/archives/96-Is-your-database-ready-for-the-Daylight-Savings-Times-change-of-2007.html

in the pg share dir:

$ /usr/sbin/zdump -v EST5EDT | grep 2007
EST5EDT  Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 EST isdst=0 gmtoff=-18000
EST5EDT  Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 EDT isdst=1 gmtoff=-14400
EST5EDT  Sun Nov  4 05:59:59 2007 UTC = Sun Nov  4 01:59:59 2007 EDT isdst=1 gmtoff=-14400
EST5EDT  Sun Nov  4 06:00:00 2007 UTC = Sun Nov  4 01:00:00 2007 EST isdst=0 gmtoff=-18000

Nice to see it in b&w on the system of interest.

Thx, Greg.

On Mon, Feb 19, 2007 at 03:06:32PM -0500, Ray Stell wrote:
> in the pg share dir:
>
> $ /usr/sbin/zdump -v EST5EDT | grep 2007

On many platforms, regardless of what directory you're in, the above
command will read timezone files from a standard directory like
/usr/share/zoneinfo, not from the current directory.  Even a relative
path like ./EST5EDT won't work; you'll need to give the full path:

zdump -v /full/path/EST5EDT

I'd suggest doing a process trace (ktrace, strace, truss, etc.) to
check what timezone file zdump is reading.  And if your system
stores its local timezone in /etc/localtime, don't forget to check
that file as well -- otherwise you might discover that your system
uses the correct DST dates for every timezone except the one you're
in.

--
Michael Fuhr