经典sql

1.查询指点日期段数据

SELECT

  *
FROM
  `poc_order_data`
WHERE `create_time` >= DATE_FORMAT(
    DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY),
    '%Y-%m-%d 12:00:00'
  )
  AND `create_time` <= DATE_FORMAT(NOW(), '%Y-%m-%d 12:00:00') ;