Hello, I'm converting old O11 SQLs to be used in Cloud.
This particular query uses a nonexistent function of 'first_day' but I'm not sure what to replace it with since I'm still a novice in SQL. Any pointers? Thank you.
-----------------
Where
to_monthyear(conversion_date) = (
case
when to_number(to_char(SYSDATE,'DD'))>=15 then to_monthyear(last_day(sysdate)+1)
when to_number(to_char(SYSDATE,'DD'))<15 then to_monthyear(FirstDay(sysdate))
end