Re: Oracle Report question

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Thu, 13 Apr 2006 17:48:05 GMT
Message-ID: <Ixo9G7.K7z@igsrsparc2.er.usgs.gov>

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 - 12:48:05 CDT