i thought following way search calls placed in 10 minute time frame
select * `call_log` start_time between ('2012-05-01 17:50:00' , '2013-05-01 18:00:00') however when run query following error
#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'limit 0, 30' @ line 2 i not sure means, , wondering if me. date formate same above too.y-m-d h:m:s
you don't need parentheses:
select * `call_log` start_time between '2012-05-01 17:50:00' , '2013-05-01 18:00:00'
Comments
Post a Comment