Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get superscripts for date in SQL?

User_LS5AKNov 24 2021

select to_char(sysdate,'ddth Month,YYYY','NLS_DATE_language=American') from dual
Output: 24th November ,2021
But i Need th as like superscript to 24

Comments
Post Details
Added on Nov 24 2021
4 comments
545 views