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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
537 views