sql server (alternate): Jesse,

If there are no time portions to the dates, you can

Select cast(End_date - Start_date as int)

That will still work with time portions, but will round up to the next int
if the partial day difference is 12 hours or more. If you want the
calendar day difference between two datetimes with time portions,
you can use datediff():

select datediff(day, Start_date, End_date)

The Search tab of Books Online is helpful for this kind of thing.
If you enter
date subtract
and have "Match similar words" selected, you should get very few
results, one of which is DATEDIFF and one of which is - (Subtract).

Steve Kass
Drew University

[quoted text, click to view]