Calculate the number of days in a date range in SQL 2005

How can I determine how many days are in @StartDate and @EndDate with  a SQL expression?
mattkovoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
SELECT DATEDIFF(dd,@Start, @End )
0
 
Kevin CrossChief Technology OfficerCommented:
Aneesh's suggestion should work for you!
0
 
mattkovoAuthor Commented:
Thanks a bunch!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.