X-Leon的博客

按日查询 select * from k_order where ( datediff ( create_time , 2020-02-02) = 0 ) and shop_id = 1001 DATEDIFF(date1,date2) 函数返回date1 - date2 的天数

MySQL的日期格式化 SELECT CURDATE( ) date, now( ) dateTime, DATE_FORMAT( now( ), ‘%Y-%m-%d’ ) dateFmt, DATE_FORMAT( now( ), ‘%Y-%m-%d’ ) dateTimeFmt, DATE_FORMAT( now( ), ‘%Y-%m-%d %H:%i:%s’ ) daymins, CURTI...