Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Superscript in the Date ex: 1st July 2024

Received Response

11

Views

1

Comments

Gundllapally Sagar

Gundllapally Sagar Rank 0 - Community Observer

Jul 23, 2024 2:24PM in Oracle Analytics Publisher

I have a requirement to get the superscript after date.

Currently am using

select to_char(sysdate,'ddth Month,YYYY','NLS_DATE_language=American') from dual
Output: 1st July ,2024
But i Need st as like superscript to 1

July 2024

0

Answers

Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

Jul 25, 2024 8:50PM

Hi @Gundllapally Sagar
This is an DB question, what is your expected output here : Jul 2024 instead of 1st July 2024?
Regards,
Arjun

0