Oracle Oracle quickly determines whether a date is a leap year or common year

Select  Case  whenTo_char (Last_day (Add_months (Trunc (Sysdate,'y'),1)),'DD')= ' -'  Then 'Common year'       Else 'Leap Year'       End  asIsleapyear fromDual

The first step: the date of the beginning of the date; the second step: the beginning date of one months is the concept of February; the third step: take the concept of the last day of February judgment, such as 28 flat, such as 29 leap

-------------------------------------------------------

Oracle Oracle quickly determines whether a date is a leap year or common year