CoderZone.org

Category: >> mySQL >> Detect Daylight Saving Time Bookmark and Share

<< lastnext >>

Snippet Name: Detect Daylight Saving Time

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

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 01st, 2009

SELECT -5 - CAST(REPLACE(TIMEDIFF(NOW(), 
UTC_TIMESTAMP()), ':00:00', '') AS SIGNED) AS isDst
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 21