Friday, October 15, 2010

making chages to Daylight Saving Time dates

The dates when Daylight Saving Time starts or ends for various countries varies from year to year, and periodically we have to update our schedule page's database. Earlier, I was doing it manually one by one, changing something like 30+ records. This was both painful and error-prone. This time, I made some SQL queries to make it relatively painless. I've saved them locally as zonestoupdate.txt - queries along the lines of
UPDATE `radiosai_zone_master` SET `dstEndDay` = '31' WHERE `dstEndDay` =25 AND `dstEndMonth` =10
for countries in Europe etc.

No comments:

Post a Comment