MySQL Forums :: General :: Time Manipulation In Query

If you want any performance out of the WHERE clause, and if you have an index on dateTimer, then turn it around:
> WHERE Date_Add(tblScvData.dateTimer, Interval '+08:00' hour_minute)
BETWEEN
'2011-10-19 00:00:00' AND '2011-10-20 23:59:59'
-->
WHERE tblScvData.dateTimer BETWEEN '2011-10-19 00:00:00' - INTERVAL '+08:00' hour_minute AND '2011-10-20 23:59:59' - INTERVAL '+08:00' hour_minute