Datediff between 2 columns in same table

Question

I've got 2 date columns in my table (start_date, end_date).

I've tried Datediff(day, start_date, end_date), but I was prompt with:

invalid column name

---

How can I calculate the date difference between these 2 columns?

Solution 1

select DATEDIFF (day,start_date,end_date) from yourtablename;

Solution 2

Should be Datediff(day, start_date, end_date). There is no 's' at the end of the day

• http://technet.microsoft.com/en-us/library/ms189794.aspx