JDCam
asked on
Oracle 9i - Select date with alpha month
Experts
I need to select a date stored in Oracle, but change the month output to 3 alpha.
Please help me do this
Here is is a current select where I return the value in YYYMMDD
how can I get the date of 20140122 to return as JAN2214 ?
I need to select a date stored in Oracle, but change the month output to 3 alpha.
Please help me do this
Here is is a current select where I return the value in YYYMMDD
SELECT
To_CHAR(TO_DATE(RCPT_EXPY_DATE),'YYYYMMDD') ORDDATE
FROM....
how can I get the date of 20140122 to return as JAN2214 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For your options, see http://www.oracle-dba-online.com/sql/date_operators_functions.htm
The function in my reply should be to_date, of course, not to_to_date :)
ASKER
your kidding.... that simple?
I has waaaaay of tryring to use DECODE
Working great... Thanks
I has waaaaay of tryring to use DECODE
Working great... Thanks