Never been to DZone Snippets before?

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

About this user

Steve Clay http://mrclay.org/

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Detect Daylight Saving Time on a MySQL server in the America/New_York timezone.

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.
to mysql timezone dst by mrclay on Jan 15, 2008
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS