Archive for February 17, 2009
Calculate an Upcoming Birthday in PL/SQL.
02 years ago
by Onno
in Programming
ADD_MONTHS(s.dateofbirth,CEIL(MONTHS_BETWEEN(sysdate, s.dateofbirth)/12)*12)
Leap-day proof :)