Get Group of Five Days between Two dates

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

i want result like following on passing two date ;

01-11-2013 to 05-11-2015 06-11-2013 to 11-11-2013 Coloumns
5 6 Data

Posted 22-Dec-13 19:30pm

madhu.gone

Updated 22-Dec-13 20:44pm

v5

Add a Solution

Comments

Maciej Los 23-Dec-13 2:27am

The difference between: 01-11-2013 and 05-11-2015 is 735 days.

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)

skydger · Answer 1 · 2013-12-22T19:44:00

Solution 1

Hello, consider to use DATEDIFF[^]

For example:

SQL

SELECT DATEDIFF(dd, CAST('2013-11-01' AS DATE), CAST('2013-11-05' AS DATE))

But this clause will return 4 for this dates pair not 5.

Posted 22-Dec-13 19:44pm

skydger

Comments

Maciej Los 23-Dec-13 2:13am

Good job! A5!
I think OP wants to count each date including start date and end date. All you need to do is to add 1 ;)

skydger 23-Dec-13 6:05am

Thanks :)

madhu.gone 23-Dec-13 2:14am

but i am passing two dates dynmically

Maciej Los 23-Dec-13 2:57am

And...

TrushnaK · Answer 2 · 2013-12-22T20:37:00

Solution 3

try this query :-

SELECT DATEDIFF(d, CAST('2013-11-01' AS datetime), CAST('2013-11-05' AS datetime)) ,DATEDIFF(d, CAST('2013-11-06' AS datetime), CAST('2013-11-12' AS datetime))

O/p:-
4 ,5

Posted 22-Dec-13 20:37pm

TrushnaK