In Teradata, we can use INTERVAL function to perform several DATE – TIME operations. Consider INTERVAL as the time-period or time-quanta between two timestamps like DAY to SECOND or YEAR to HOUR etc.
Let's see below few examples using Teradata Interval Function.
In above examples, we saw different ways in which we can subtract various interval types from timestamp. Also when we subtract 2 timestamp columns, the output is INTERVAL.