Quick Search:
 
 mySQL: Detect Daylight Saving Time Jump to:  
Category: >> mySQL >> Detect Daylight Saving Time  

<< lastnext >>

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


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org