判断方式:根据二月份的最后一天是不是29天,判断是否是闰年。
- SELECT
- YEAR(CURRENT_DATE ()) AS YEAR,
- CASE
- WHEN DAY (
- last_day(
- date_add( concat( YEAR ( CURRENT_DATE ()), '-01-01' ), INTERVAL 1 MONTH )))= 29 THEN
- '润年' ELSE '平年'
- END AS IS_LEAP_YEAR