The best way to fix it, is to handle everything in GMT, and take the time to go through and correct it. In perl you can use gmtime(), in mysql you can use UTC_TIMESTAMP(), UTC_TIME(), UTC_DATE().