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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
