Calculate an Upcoming Birthday in PL/SQL.
February 17, 2009 by Reboot · Leave a Comment
ADD_MONTHS(s.dateofbirth,CEIL(MONTHS_BETWEEN(sysdate, s.dateofbirth)/12)*12)
Leap-day proof :)
Software Engineer - http://www.linkedin.com/in/orlissenberg
Onno's Tweets- http://open.spotify.com/track/2O8YJmOg9lOgn5JNHF9Qi9 Spotify: Randy Newman – You've Got A Friend In Me !!!
- More "hidden" skins in the new LoL patch, yay!! http://bit.ly/cWlwkn
- I smell a bit like raw sewage ;-) Team building day was kinda fun though!
- #dpc10 second day, good start, lets keep this up for the rest of the day.
- Congratz RIOT on finishing the server migration already, I've got STATS! (http://blog.ingol.nl)