select date of perticular month

Question

0.00/5 (No votes)

See more:

i have list of dates :

01/02/2013
02/02/2013
03/02/2013
04/02/2013
05/02/2013
01/03/2013
02/03/2013
03/03/2013

from this i have to select list of dates of second month only(meance in february).
what is query for that?

Posted 19-Feb-13 21:01pm

Member 9511889

Add a Solution

Comments

Shubh Agrahari 20-Feb-13 3:53am

Is you using real format of date time or just using simple string for list box...???

3 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)

_Amy · Answer 1 · 2013-02-19T21:40:00

Solution 1

Try this:

SQL

SELECT MyDateTimeColumn FROM TableName WHERE MONTH(MyDateTimeColumn)=2 --February

--Amit

Posted 19-Feb-13 21:40pm

_Amy

Susheel Kumar Verma · Answer 2 · 2013-02-19T21:46:00

Solution 2

Try this It's working

SQL

select * from tableName where MONTH(columnName)=2

Note : Datecolumn of your table should in datetime format

Posted 19-Feb-13 21:46pm

Susheel Kumar Verma

Motamas · Answer 3 · 2013-02-19T21:53:00

If your list already fetched from the DB and your list implements the IEnumearble (or IQueryable) interface like List<> or IEnumerable<> and it is a list of DateTime struct then you can use LINQ like:

var query = _list.where(a => a.Month == 2);

OR

var query2 = from i in _list where i.Month == 2 select i;