WHERE `updateTime`>='2011-07-07 9:00:00' AND `updateTime`< DATE_ADD('2011-07-07 9:00:00', INTERVAL +1 HOUR) WHERE (UNIX_TIMESTAMP(`updateTime`) - UNIX_TIMESTAMP('2011-07-07 9:00:00') <= 3600) and (UNIX_TIMESTAMP(`updateTime`) - UNIX_TIMESTAMP('2011-07-07 9:00:00') >=0)
两种SQL的时间段查询方法。
转载于:https://www.cnblogs.com/k1988/archive/2011/07/07/2165588.html