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?

Answer 1

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