Hoe To Resolve It I M Getting Extra Data While Calling Data Between Date

Question

0.00/5 (No votes)

See more:

i have a database with a table like:-

C#

ID   Name   Amount   Date
001  abc    200      01/05/2014
001  abc    200      02/05/2014
001  abc    200      03/05/2014
001  abc    200      31/05/2014
001  abc    200      01/06/2014
001  abc    200      02/06/2014

when i am calling data with query

SQL

select * from table_name where Date_ between '01/05/2014' and '31/05/2014'  ORDER BY CONVERT(DateTime, Date_, 103) DESC";

it is showing me extra data of 01/06/2014 and 02/06/204 along with data of date between 01/05/2014 and 31/05/2014

so how to resolve it
i trired

Posted 4-Sep-14 18:37pm

Shantanu sinha

Updated 4-Sep-14 19:32pm

Thanks7872

v3

Add a Solution

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)

*Suvabrata Roy* · Answer 1 · 2014-09-04T18:50:00

Solution 2

Hi,

Between means start from that date till that date.

it means that including 01/05/2014 and 31/05/2014

If you want to exclude them then try > and < operator before using be sure there is no Time is attached with your date then it may produce a wrong output.

Posted 4-Sep-14 18:50pm

Suvabrata Roy

Comments

Shantanu sinha 5-Sep-14 1:17am

txs for reply

Shantanu sinha · Answer 2 · 2014-09-04T19:56:00

Solution 3

select * from expence where CONVERT(DateTime, Date_, 103) >= CONVERT(DateTime, '01/08/2014', 103) and CONVERT(DateTime, Date_, 103) <= CONVERT(DateTime, '31/08/2014', 103) order by Date_ DESC

Posted 4-Sep-14 19:56pm

Shantanu sinha

Comments

Suvabrata Roy 5-Sep-14 11:19am

Hi Shantanu,
I am bit worried about your output.
You have always convert values into DateTime ( In don't know why ) for doing that it will not make any format changes.
What Should be your query : I am assuming that Date_ is a dateTime Field

select * from expence where Date_>= CONVERT(DateTime, '01-Aug-2014')
and Date_ <= CONVERT(DateTime, '31-Aug-2014') order by Date_ DESC

Gihan Liyanage · Answer 3 · 2014-09-04T18:48:00

Solution 1

SQL

select * from table_name
where 
Date >= '01/05/2014' and Date <= '31/05/2014'