Newsgroups: comp.databases.oracle.tools Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news4.google.com!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Oracle Report question In-Reply-To: <1144946625.828888.172530@i40g2000cwc.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-59.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5 (Windows/20051201) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1144946625.828888.172530@i40g2000cwc.googlegroups.com> Mime-Version: 1.0 Date: Thu, 13 Apr 2006 17:48:05 GMT Lines: 36 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:70629 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@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