msyql
1.查询年月日
SELECT 。。。
WHERE ( DATEDIFF ( ro.end_time, '2021-04-08' ) = 0 ) AND ro.rider_id = '8001' AND ro.state = 2;
SELECT。。。
WHERE ( DATE_FORMAT( ro.end_time, '%Y-%m' ) = '2021-04' ) AND ro.rider_id = '8001' AND ro.state = 2;
SELECT * FROM tz_rider
原创
2021-04-27 22:50:40 ·
60 阅读 ·
0 评论