DATEDIFF_IN_DAYS SQL Function
Returns the difference between 2 timestaps expressed in number of days.
Both date values are required and must evaluate to a datetime. If at least one of the arguments contains time values, the function will deliver float values. To prevent this, use the TIMESTAMP_TO_DATE function to convert the argument(s) to a format that does not contain time information.
This is a convertible function resolved by USoft and thus supported on all RDBMS platforms.