| From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | dst 2007? |
| Date: | 2007-02-19 20:06:32 |
| Message-ID: | 20070219200632.GA25911@cns.vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2007-02-19 23:01:30 | Re: dst 2007? |
| Previous Message | Dmitry Morozovsky | 2007-02-19 18:30:07 | grant model in PostgreSQL 8.2 |