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?

[Webinar] Streamline your web hosting managementRegister Today

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
All Courses

From novice to tech pro — start learning today.