Re: Oracle Report question

From: Brian Peasland <>
Date: Thu, 13 Apr 2006 17:48:05 GMT
Message-ID: <>

mp wrote:
> How do we display superscript format on date (i.e. st on the March
> 31st, 2006)? Is this possible in Oracle Apps Reports?

Not specifically related to any application, but rather, using the supplied SQL functions available to any app. Use the TO_CHAR function to format your date output:

SQL> SELECT TO_CHAR(sysdate,'Month DDTH,YYYY') FROM dual;


April 13TH,2006

The following document shows all of the format models for date values handed to the TO_CHAR function:



Brian Peasland

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Thu Apr 13 2006 - 19:48:05 CEST

Original text of this message