disthe
lastdayofthemo
thoriftheresulti
gmo
thhasfewerdaystha
thedaycompo
e
tofdthe
theresultisthelastdayoftheresulti
gmo
thOtherwisetheresulthasthesamedaycompo
e
tasdExample
SELECTTO_CHARADD_MONTHShiredate1DDMONYYYY