Question: how to calculate days between two dates in teradata?
Answer: 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.