mysql查询当天的数据

SELECT *
FROM form_fxypycngg
where gmt_created_on >=CAST(SYSDATE()AS DATE) AND gmt_created_on<=CAST(SYSDATE()AS DATE) + INTERVAL 1 DAY

 

AND txrq >= UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE))*1000
      AND txrq <=UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE) + INTERVAL 1 DAY)*1000