Oracle LEAP years
Posted by
www.2012updates.com
Labels:
PL/SQL
select
year,
decode( mod(year, 4), 0,
decode( mod(year, 400), 0, 'Leap Year',
decode( mod(year, 100), 0, 'Not a Leap Year', 'Leap Year')
),
'Not a Leap Year'
) as leap_year_indicator
from my_table
/
Subscribe to:
Post Comments (Atom)
Post a Comment