This following query returns zero rows, yet I'm sure there is data there. SELECT class,time_stamp FROM cf_status_log WHERE class like 'any' AND ( time_stamp BETWEEN now() AND ( timestamp with time ...