MONTH arithmetic is HARD! Even with ADD_MONTHS

Even with the nifty ADD_MONTHS function, you need to take when trying to make sense of month arithmetic when dealing with dates. Here are some of the common gotchas
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#sql #database

[@MarcDunivan-WO]

Stop using months.... a month really isn't a fix time interval...not all months have 31 days, not all have 30 days... February. Use YYYY-DDD... 10 day increments.

[@DatabaseDude]

Amen, but I 'm just responding the questions that come in from customers via asktom.oracle.com.