MYSQL date between DATE_SUB(NOW() AND NOW() not working -

MYSQL date between DATE_SUB(NOW() AND NOW() not working -

i trying set table updated every hr initial creation of table.

i using 2 next sql queries.

create table temptab select id, intpos, date transverse date between '2014-06-01 00:00:00' , '2014-11-10 07:57:01' , intpos in ('w1','w2','w3','w4');

sql returns 13926 results

create event gen on schedule every '60:00' minute_second insert temptab (id, intpos, date) select id, intpos, date transverse date between date_sub(now(), interval 1 hour) , now() , intpos in ('w1','w2','w3','w4');

sql returns 0 results

the create event problem, although have ran select know there data:

select * transverse date between date_sub(now(), interval 1 hour) , now() , intpos in ('w1','w2','w3','w4')

this gives 200 results.

can tell me on earth doing wrong ?

mysql