sql:TIMESTAMPDIFF获取2个日期的差值

select TIMESTAMPDIFF(minute, STR_TO_DATE(CONCAT(DATE_FORMAT(now(),'%Y-%m-%d'),dri_time), '%Y-%m-%d %H:%i:%s'),now())from dc_shop
posted @ 2021-11-08 15:25  Tester-**  阅读(98)  评论(0编辑  收藏  举报