Teradata - 时间戳差异 - 间隔文件溢出错误

Question

我正在尝试减去两个 TIMESTAMP 文件并希望以分钟为单位获得差异。

SELECT EXTRACT(MINUTE FROM ( CAST(END_DT AS TIMESTAMP(0)) - CAST(START_DT AS TIMESTAMP(0)) MINUTE(4) TO SECOND)) + EXTRACT(SECOND FROM (CAST(END_DT AS TIMESTAMP(0)) - CAST(START_DT AS TIMESTAMP(0)) MINUTE(4) TO SECOND)) * 1.00 / 60 
from tableA

但是我收到间隔文件溢出错误。

Answer 1

我能够使用以下方法实现解决方案

(EXTRACT(HOUR FROM TIME_DIFF) * 60) + EXTRACT(MINUTE FROM TIME_DIFF) + (EXTRACT(SECOND FROM TIME_DIFF) * 1.00 / 60)

TIME_DIFF在哪里(ACTL_END_DT - ACTL_START_DT) DAY(4) TO SECOND