weixin_39653050的博客

tidb日期函数使用参考文档https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_yearweek

函数介绍：YEARWEEK(date), YEARWEEK(date,mode)Returns year and week for a date. The year in the result may be different from the year in the date argument for the first and the last week of the year.传入一个日期，返回这个日期是这一年的第几周。第二个参数mode的作用是每周的第一天从哪一天开始计算一般情况下，我们