Displaying only february month data in SQL

Question

0.00/5 (No votes)

See more:

Hi
I have orderid and orderdate column. orderdate containing date format like 'yyyy-mm-dd'.
i want to display the order placed in the month of February.
How can we achieve this in the SQL?

Waiting for quick response.

What I have tried:

I have tried with month and datepart function in sql but it does not work.

Posted 14-Jul-22 21:22pm

prasad patil Jul2022

Updated 15-Jul-22 3:02am

Add a Solution

Comments

Richard MacCutchan 15-Jul-22 3:25am

"orderdate containing date format like 'yyyy-mm-dd'."
Which is completely wrong. SQL has perfectly useful Date/DateTime types, which allow you to extract the month without complicated programming.

prasad patil Jul2022 15-Jul-22 3:28am

give me solution to fetch only February month

2 solutions

Solution 2

Thank U all for your response.
Below is the solution for the problem.

SELECT * from orders where (DATEPART(mm, orderdate)) = 2

Posted 15-Jul-22 3:02am

prasad patil Jul2022

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)

OriginalGriff · Accepted Answer · 2022-07-14T21:43:00

Solution 1

SQL

SELECT ... WHERE DATEPART(m, MyDateColumn) = 2

Posted 14-Jul-22 21:43pm

OriginalGriff

Comments

prasad patil Jul2022 15-Jul-22 4:10am

I was trying the solution query u have given in w3school site database but it is showing error like, m is not defined.

CHill60 15-Jul-22 4:32am

try month instead. Or look up DATEPART in w3schools SQL Server DATEPART() Function[^]

prasad patil Jul2022 15-Jul-22 4:51am

i am trying to execute the below query in w3school sql server.

SELECT * from orders WHERE DATEPART(month, orderdate) = 2

but it is showing error like month is not defined

0x01AA 15-Jul-22 8:52am

Have look here, SQLite: How to Extract the Day, Month, and Year from a Date in SQLite[^]
This should work: SELECT * from orders WHERE strftime('%m', orderdate) = '02'