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

SELECT
To_CHAR(TO_DATE(RCPT_EXPY_DATE),'YYYYMMDD') ORDDATE
FROM....

Open in new window


how can I get the date of 20140122  to return as JAN2214 ?
LVL 1
JDCamAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
This should do it I think:

select to_char(to_TO_DATE(RCPT_EXPY_DATE), 'MONDDYY') ORDDATE
0
 
DavidSenior Oracle Database AdministratorCommented:
0
 
Steve WalesSenior Database AdministratorCommented:
The function in my reply should be to_date, of course, not to_to_date :)
0
 
JDCamAuthor Commented:
your kidding.... that simple?
I has waaaaay of tryring to use DECODE

Working great... Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.