Re: Oracle Report question
Date: 13 Apr 2006 11:51:19 -0700
[Quoted] I know the format. But the problem is the 'st' in March 31st, 2006 should appear a little up and in smaller font like in real superscript notation. If you try typing the same thing in MSWord, you'll know what I mean.
Brian Peasland wrote:
> 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 - 20:51:19 CEST