根据具体的业务需求,把下面sql语句的时间换成自己想要格式化的时间即可。
年
SELECT date_format( '2021-07-05 14:55:17', '%Y年' ) sj
月
SELECT date_format( '2021-07-05 14:55:17', '%Y年%m月' ) sj
季度
SELECT concat(CONVERT ( date_format( '2021-07-05 14:55:17', '%Y' ) USING utf8mb4 ),'年第',floor(((date_format( '2021-07-05 14:55:17', '%m' ) + 2 ) / 3 )),'季度' ) sj
周
SELECT concat(CONVERT ( date_format( '2021-07-05 14:55:17', '%Y年%m月' ) USING utf8mb4 ),'第',IF((MONTH ((('2021-07-05 14:55:17' + INTERVAL (-( dayofmonth( '2021-07-05 14:55:17' )) + 1 ) DAY ) - INTERVAL weekday(('2021-07-05 14:55:17' + INTERVAL (-( dayofmonth( '2021-07-05 14:55:17' )) + 1 ) DAY )) DAY )) = MONTH (('2021-07-05 14:55:17' + INTERVAL (-( dayofmonth( '2021-07-05 14:55:17' )) + 1 ) DAY ))),(( dayofmonth( '2021-07-05 14:55:17' ) + weekday(('2021-07-05 14:55:17' - INTERVAL dayofmonth( '2021-07-05 14:55:17' ) DAY ))) DIV 7 ),(((dayofmonth( '2021-07-05 14:55:17' ) + weekday(('2021-07-05 14:55:17' - INTERVAL dayofmonth( '2021-07-05 14:55:17' ) DAY ))) DIV 7 ) + 1 )),'周' ) sj