Subracting Teradata timestamps

[Guest_imported]

How can I get the difference between two TeraData timestamps, and return days, hours, or minutes?

 

[BillDHS]

If the attributes are defind as timestamps, you should be able to do something like:

Select (Timestamp2 - Timestamp1) DAY(4)
From Table1 ;

Change DAY to HOUR or MINUTE for those periods. The (4) is the number of digits in the results, 4 is the max, so for example if the timestamps are 7 days apart, you would get an error deriving Minutes.

 

[tdatgod]

Hi,
The difference between 2 timestamps is an interval.
This isn't Teradata specific it is ANSI SQL.

You must tell to parser which format you want the answer in.

sel column1 - column2 Day(4) to seconds(6)
from blort;

This means the answer would be the number of Days down to the second difference between the 2 dates.

You can review my note about intervals in....

Thread328-150396


Maybe we should make this a FAQ....