Solved

Oracle 9i - Select date with alpha month

Posted on 2014-01-22
4
630 Views
Last Modified: 2014-01-22
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 ?
0
Comment
Question by:JDCam
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 39801312
This should do it I think:

select to_char(to_TO_DATE(RCPT_EXPY_DATE), 'MONDDYY') ORDDATE
0
 
LVL 23

Expert Comment

by:David
ID: 39801318
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39801342
The function in my reply should be to_date, of course, not to_to_date :)
0
 

Author Closing Comment

by:JDCam
ID: 39801355
your kidding.... that simple?
I has waaaaay of tryring to use DECODE

Working great... Thanks
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now