SQL执行出错

[wang316902972]

SELECT [lpid],[channel_id],[uid],[id],[ticket],1.0*[money]/100 as money,[order_time]
FROM ss_pay_cb_qdf
WHERE '2020/7/3 0:00:00' <= order_date AND order_date <= '2020/7/10 0:00:00' AND lpid=216

这样的查询语句会自动把时间的''去掉 然后报错

SELECT  
  1.0* money/ 100  as  money, order_time  
FROM  
  ss_pay_cb_qdf  
WHERE  
  2020/ 7/ 3  0: 00: 00  <= order_date  
  AND  order_date  <= 2020/ 7/ 10  0: 00: 00  
  AND  lpid= 216

MySQL执行出错

syntax error at position 77 near '0'

[martianzhang]

未复现

SELECT *
FROM ss_pay_cb_qdf
WHERE '2020/7/3 0:00:00' <= order_date AND order_date <= '2020/7/10 0:00:00' AND lpid=216;