Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle 9i - Select date with alpha month

Posted on 2014-01-22
4
651 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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

840 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