Teradata SQL

Calculate time difference in SQL / Teradata

about 4 months ago

Code description

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.

Code snippet

-- 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;

Other versions

PowerShell

Calculate time difference in PowerShell

This code snippet shows how to calculate time differences.

View detail
SQL Server T-SQL

Calculate time difference in T-SQL / SQL Server

This code snippet shows how to calculate time differences.

View detail