Forum Stats

  • 3,767,980 Users
  • 2,252,736 Discussions
  • 7,874,399 Comments

Discussions

How to get superscripts for date in SQL?

User_LS5AK
User_LS5AK Member Posts: 5 Green Ribbon

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

Answers