I need to determine the 15th of the following month in an Oracle Select statement based on a date field.
select sysdate "MY DATE",
add-code-here "THE 15TH"
sysdate is substituted here in place of a database field.
This code works except for when the selected date falls in December
-- compute year
-- compute month
substr(to_char('00' || (to_char(sysdate,'mm') + 1)),-2,2) ||
-- add day
'yyyymmdd') "CAL DATE"