select create_time,
left (case when hour(create_time) < 7 then DATE_ADD(create_time,INTERVAL -1 DAY) else create_time end ,10) as day_ddddddddddddd
from kjy_dsxtsfbzlorder by create_time desc
效果:
select create_time,
left (case when hour(create_time) < 7 then DATE_ADD(create_time,INTERVAL -1 DAY) else create_time end ,10) as day_ddddddddddddd
from kjy_dsxtsfbzlorder by create_time desc
效果: