sql datediff

sql datediff function returns the time between two dates

datediff(date_1, date_2)

for example

select datediff('2014-03-05', '2014-03-04')

returns

1