datediff problem

[imranafsari]

Hi, I am using sql server 2005. When I am finding difference between two date I am getting one day less For example select datediff(d , '2008-09-01' , '2008-09-05') I am getting 4 days I want it to be five day as 1,2,3,4,5 that is it should start from date to todate How can I do it Please help Thank you

imran khan

[ChandraRam]

Add 1 to the result. DateDiff gives you the interval between the two dates.

[Manas Bhardwaj]

imranafsari wrote:

select datediff(d , '2008-09-01' , '2008-09-05')

5 - 1 = 4 Seems ok to me...add 1 to get your desired result.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[Blue_Boy]

select datediff(d , '2008-09-01' , '2008-09-05')+1

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[nelsonpaixao]

let it be :laugh:

nelsonpaixao@yahoo.com.br trying to help & get help