Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Report question

Re: Oracle Report question

From: mp <minakshipauranik_at_gmail.com>
Date: 13 Apr 2006 11:51:19 -0700
Message-ID: <1144954278.356661.210600@j33g2000cwa.googlegroups.com>


Thanks Brian!!

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.

-mp

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;
>
> TO_CHAR(SYSDATE,'MO
> -------------------
> April 13TH,2006
>
> The following document shows all of the format models for date values
> handed to the TO_CHAR function:
>
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34510
>
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_nospam.peasland.net
> http://www.peasland.net
>
> 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 - 13:51:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US