How can i get only month from a field using sql query?

Question

0.00/5 (No votes)

See more:

In my table i have one field which contains the date, i want to take only month from that
is it possible?
similarly how can i take month from system date?

Posted 26-Sep-12 5:19am

Am Gayathri

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2012-09-26T05:22:00

Solution 1

You can use the DATEPART function to get the month number or DATENAME function to get the month name.

SQL

select datepart(month,Mydate), datename(month,Mydate)

Source[^]

See Solution 2 for the oracle answer. (I didn't see that tag, sorry)

Posted 26-Sep-12 5:22am

fjdiewornncalwe

Updated 26-Sep-12 5:30am

v2

Comments

RaisKazi 26-Sep-12 11:36am

5ed. Its always a great fun to work with DATEPART, DATENAME and other Sql Server functions.!

Maciej Los 26-Sep-12 15:55pm

Good work! +5

RaisKazi · Answer 2 · 2012-09-26T05:27:00

Solution 2

For SQL Server

SQL

SELECT MONTH(MyDateColunm) from MyTable;

To get System/Current Month.

SQL

SELECT MONTH(GETDATE());

For Oracle

SQL

select to_char(MyDateColunm, 'Month') from MyTable;

To get System/Current Month.

SQL

select to_char(sysdate, 'Month') from dual;

Posted 26-Sep-12 5:27am

RaisKazi

Comments

fjdiewornncalwe 26-Sep-12 11:30am

+5. I didn't see the oracle tag.

RaisKazi 26-Sep-12 11:35am

Thank you Marcus!.