DZone Snippets: dst code http://snippets.dzone.com/posts Sat, 26 Jul 2008 20:32:08 GMT DZone Snippets: dst code Detect Daylight Saving Time on a MySQL server in the America/New_York timezone. http://snippets.dzone.com/posts/show/4986 <code> <br />SELECT -5 - CAST(REPLACE(TIMEDIFF(NOW(), UTC_TIMESTAMP()), ':00:00', '') AS SIGNED) AS isDst <br /></code> <br />To test in other timezones, replace -5 with your local standard time GMT offset. Tue, 15 Jan 2008 19:21:42 GMT http://snippets.dzone.com/posts/show/4986 mrclay (Steve Clay)