MYSQL基操
1.YEARWEEKMySQL 的 YEARWEEK 是获取年份和周数的一个函数,函数形式为 YEARWEEK(date[,mode])例如 2010-3-14 ,礼拜天SELECT YEARWEEK('2010-3-14') 返回 11 SELECT YEARWEEK('2010-3-14',1) 返回 10 查询当前这周的数据SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,'%Y-%m
原创
2021-06-30 17:30:36 ·
1542 阅读 ·
0 评论