Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How can I extract a month name from a date using pl/sql

Posted on 2013-01-22
3
Medium Priority
?
1,249 Views
Last Modified: 2013-01-22
How can I extract a month name from a date using pl/sql

I'm extracting the number for selection and would like to display the month name
0
Comment
Question by:conardb
  • 2
3 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 38807385
to_char(sysdate,'Month)

Substitute sysdate with your date variable/field.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38807391
>>I'm extracting the number

If you just have a 'number': a Case statement would be the easiest but in SQL:
to_char(to_date(yourNumber,'MM'),'Month')
0
 

Author Comment

by:conardb
ID: 38807414
Ok, thanks
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

971 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