mySQL: Detect Daylight Saving Time - To test in other timezones, replace '-5' with your local standard time GMT offset.

Quick Search:

mySQL: Detect Daylight Saving Time

Jump to:

Snippet Name: Detect Daylight Saving Time

Description: To test in other timezones, replace '-5' with your local standard time GMT offset.

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 01st, 2009

SELECT -5 - CAST(REPLACE(TIMEDIFF(NOW(), 
UTC_TIMESTAMP()), ':00:00', '') AS SIGNED) AS isDst