SELECT DATE_FORMAT(‘2022-01-01 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-03 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-04 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-05 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-09 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-10 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-17 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-24 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-01-31 00:00:00’,’%Y%u’); SELECT DATE_FORMAT(‘2022-02-07 00:00:00’,’%Y%u’); 获取每周,是从0开始计算的 SELECT MONTH(‘2022-01-01’); SELECT MONTH(‘2022-01-11’); SELECT MONTH(‘2022-01-21’); SELECT MONTH(‘2022-01-31’); SELECT MONTH(‘2022-02-01’); SELECT MONTH(‘2022-03-01’); SELECT MONTH(‘2022-04-01’); SELECT MONTH(‘2022-05-01’); 获取每个月 SELECT QUARTER(‘2022-01-01’); SELECT QUARTER(‘2022-02-01’); SELECT QUARTER(‘2022-03-01’); SELECT QUARTER(‘2022-04-01’); SELECT QUARTER(‘2022-04-20’); 获取每个季度