question realated searching

Question

0.00/5 (No votes)

See more:

.NET

.NET4

how we can search data according to month from database in asp.net c#

Posted 18-Feb-14 18:12pm

Member 10426233

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)

Krunal Rohit · Answer 1 · 2014-02-18T18:20:00

Go for MONTH[^].

id happend_at<br />
-- ----------------<br />
1  2009-01-01 12:08<br />
2  2009-02-01 12:00<br />
3  2009-01-12 09:40<br />
4  2009-01-29 17:55

And let's say you want to execute to find all the records that have a happened_at during the month 2009/01 (January 2009). The SQL query would be:

SQL

SELECT id FROM things
WHERE MONTH(happened_at) = 1 AND YEAR(happened_at) = 2009

<br />
output<br />
id<br />
---<br />
1<br />
3<br />
4

src : stackoverflow[^]
-KR

Ankur^\m/ · Answer 2 · 2014-02-18T18:20:00

Your question is not clear. But from what I understand, you need to have a datetime column in your table from which you want filtered data. Update this column with current time every time you insert or update a record. You will need to use WHERE clause[^] to filter the data. If you need to sort them use ORDER BY clause[^].
Also, Date and Time Data Types and Functions[^] would help you filtering date time data.

If this isn't what you want, you need to update your question and add more detail by selecting 'Improve Question' link below your question.

question realated searching

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0