This code snippet shows how to calculate time differences.
DATEDIFF function is not implemented in Teradata. Thus we need to use other approach to calculate time difference.
-- for calculate days difference, we can directly use minus (-) operator SELECT DATE'2019-07-16' - DATE'2019-06-01' AS Diff_Days; -- month different SELECT (DATE'2019-07-16' - DATE'2019-06-01') MONTH(4) AS Diff_Months;
info Last modified by Raymond at 7 months ago