Re: Oracle Report question
Date: Thu, 13 Apr 2006 17:48:05 GMT
> 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;
The following document shows all of the format models for date values handed to the TO_CHAR function:
-- =================================================================== 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" - UnknownReceived on Thu Apr 13 2006 - 19:48:05 CEST