friend
DATEDIFF(datetime2, datetime1, "unit").
Numeric. Calculates the difference between two date/time values and returns an integer (with any fraction component truncated) in the specified date/time units, where datetime2 and datetime1 are both date or time format variables (or numeric values that represent valid date/time values), and "unit" is one of the following