SELECT SUM(CAST(DATETIME1 - DATETIME2 AS int))  AS NUMDAYS

>
>How do you SUM number of days difference between two DateTime type fields as following:
>
>

>select SUM( DATETIME1 - DATETIME2) AS NUMDAYS
>