SQL - Query help

Question

I have problem to calculate number of dates,

how to get date minus date = int value in sql 2005 Out Put :

(1/1/2009 12:00:00 AM - 5/1/2009 12:00:00 AM) = 4

Please let me know

Answer 1

SELECT DATEDIFF(dd, startDate, EndDate)

Answer 2

select datediff(dd, '2009/01/01', '2009/01/05')