Reference Guide > TDV Support for SQL Functions > Date Functions > TIMESTAMPDIFF
 
TIMESTAMPDIFF
The TIMESTAMPDIFF() function sreturns a value after subtracting a datetime expression from another.
Syntax
TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2);
Example
SELECT TIMESTAMPDIFF(SQL_TSI_year,'1902-1-1 12:59:00','-1901-12-1 13:59:00')