1.Oracle数据库中判断是否为闰年的方法
function f_is_leap_year(i_date in date) return boolean as
v_feb_last_day varchar2(2);
begin
select to_char(last_day(to_date(to_char(i_date,
'yyyy') || '0201',
'yyyymmdd')),
'dd')
into v_feb_last_day
from dual;
if v_feb_last_day = '29' then
return true;
else
return false;
end if;
end f_is_leap_year;
2.Oracle数据库判断是否为2月的最后一天
function f_is_last_date_in_Feb(i_day in date)
return boolean is
v_last_date_feb Date;
begin
v_last_date_feb:=to_date( to_char(i_day,'yyyy')||'0301','yyyymmdd')-1;
if i_day=v_last_date_feb then
return true;
else
return false;
end if;
end f_is_last_date_in_Feb;