mysql时间string格式转换成data格式

SELECT
sum(sendoutTotalCount)外发总调用数,sum(sendoutSuccesses)外发成功调用数,sum(invocationStatus_200)外发成功且有效调用数,currentWindowTime 调用时间
FROM
`t_ucc_aggr`
WHERE
to_days(currentWindowTime) >= to_days('2019-12-11')
and to_days(currentWindowTime) < to_days('2019-12-13')
and company = 08
AND product = 02;
and channel=029;
AND channel = 034;
--
--
日期时间转换语句
to_days(currentWindowTime) >= to_days('2019-12-11')

posted @ 2020-07-31 10:02  小正哥  阅读(377)  评论(0编辑  收藏  举报