X-Leon的博客

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

MySQL的日期格式化SELECTCURDATE( ) 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...