How to get superscripts for date in SQL?

User_LS5AK · Nov 24, 2021 5:52PM

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

thatJeffSmith-Oracle · Nov 24, 2021 6:43PM

It's kinda hacky, but sure with HTML rendering it's possible.

select '<HTML><p>' || to_char(sysdate, 'DD') || '<sup>th</sup>' || to_char(sysdate, 'Month, YYYY') ||'.</p></html>' as superscript from dual;

User_LS5AK · Nov 25, 2021 7:11AM

Thanks smith, but I am using Oracle SQL and not MY sql

this HTML script in sql not working for me

Lothar Armbrüster · Nov 25, 2021 3:08PM

Well, that is in fact Oracle SQL. MySQL does neither have sysdate nor dual.

If you don't use SQL Developer but SQL*Plus or any other client tool, then you are asking in the wrong forum.

thatJeffSmith-Oracle · Nov 27, 2021 2:57AM

Yeah that's Oracle. My real answer is the best way to do this is on your app, not via SQL.

Forum Stats