DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Steve has posted 12 posts at DZone. View Full User Profile

Detect Daylight Saving Time On A MySQL Server In The America/New_York Timezone.

01.15.2008
| 4492 views |
  • submit to reddit
        
SELECT -5 - CAST(REPLACE(TIMEDIFF(NOW(), UTC_TIMESTAMP()), ':00:00', '') AS SIGNED) AS isDst
To test in other timezones, replace -5 with your local standard time GMT offset.