Auto detect daylight savings with query using NOW()

[Scooby08]

I had a query that was selecting the correct data up until daylight savings time a week ago.. Here is it:

 

SELECT * FROM table WHERE (Time_TS BETWEEN NOW() AND NOW() + INTERVAL 24 HOUR) ORDER BY Time_TS

 

Now I need it to select NOW() + 1 hour and I did this:

 

SELECT * FROM table WHERE (Time_TS BETWEEN DATE_ADD(NOW(), INTERVAL 1 HOUR) AND DATE_ADD(NOW(), INTERVAL 1 HOUR) + INTERVAL 24 HOUR) ORDER BY Time_TS

 

My question is can that be written some way to automatically detect when daylight savings is in effect and run the proper query, rather than having to change the code manually when daylight savings hits??

 

MySQL 5.0.90

 

 

[PFMaBiSmAd]

If the time zone database that mysql uses is up to date (which also tells it when the DST start/end dates are) and the time zone setting that is in effect at the time the query is executed is correct (some time zones don't use DST while the one you are in does) and the date/time setting on the server is correct, NOW() should give the correct value.

 

Where is this msyql server running? On a web host somewhere or on a development system?

[Scooby08]

On a web host somewhere..

[fenway]

Unless you use TIMESTAMP columns, time zones in mysql have no effect whatsoever on DATE/DATETIME.