Forum Stats

  • 3,780,685 Users
  • 2,254,424 Discussions
  • 7,879,412 Comments

Discussions

How to get superscripts for date in SQL?

User_LS5AK
User_LS5AK Member Posts: 10 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