how to calculate days between two dates in teradata?
Subtract DATE values to get days The following query finds the difference between two DATE values and gives us the number of days. SELECT (DATE '2019-01-10' - DATE '2018-12-28') DAY; The result of the above-given query is as follows. The difference between two date values is 12.