Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT TO_CHAR((SYSDATE + 1),'Month DD (ddspth) "of year" YYYY') AS tomorrow FROM DUAL;

TOMORROW

March     01 (first) of year 2024

SELECT TO_CHAR((SYSDATE + 1),'FMMonth ddth "of year" YYYY') AS tomorrow FROM DUAL;

TOMORROW

March 1st of year 2024

alter session set nls_date_language = 'French';
SELECT TO_CHAR((SYSDATE + 1),'FMMonth ddth "of year" YYYY') AS tomorrow FROM DUAL;

TOMORROW

Mars 1st of year 2024

SELECT TO_CHAR((SYSDATE + 1),'FMMonth ddth "of year" YYYY', 'nls_date_language=English') AS tomorrow FROM DUAL;

TOMORROW

March 1st of year 2024