arathorn2005's blog

Determine in MySQL if we are in summer time or winter time (dayl

Fri, 2009-10-02 13:59 — arathorn2005

Taxonomy upgrade extras:

[http://www.blogger.com/profile/12606038649636876830 arathorn2005] said…

Nice approach!

Try this:

SELECT IF(TIMESTAMPDIFF(HOUR , UTC_TIMESTAMP(), SYSDATE()) = 2, ‘summer time’, ‘winter time’) AS TIME;