I am using
DATEDIFF(d, @Date, @ExDate) as T
to get the number of days between
. I got the number of days. But I want to the fraction T/365 for some calculation. If I do this I got 0 because it returns the time. What should I do to get that value?