Question: how to calculate difference between two dates in teradata?
Answer: Let's see how to use this special type of syntax to take the difference of two dates in Teradata. SELECT (DATE 'YYYY-MM-DD' - DATE 'YYYY-MM-DD') UNIT; In this special format, the extraction of higher unit value ignores the smaller unit values.