Superscript in the Date ex: 1st July 2024

Gundllapally Sagar

I have a requirement to get the superscript after date.

Currently am using

select to_char(sysdate,'ddth Month,YYYY','NLS_DATE_language=American') from dual
Output: 1st July ,2024
But i Need st as like superscript to 1

date.PNG

July 2024

Mallikarjuna Kuppauru-Oracle

Hi @Gundllapally Sagar

This is an DB question, what is your expected output here : Jul 2024 instead of 1st July 2024?

Regards,

Arjun