Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 23 Apr 2015 @ 15:54:34 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Subtracting two TIMESTAMP
From:   Tewksbury, Kevin

In 13.10 I get a different error message, but try removing the (0) from the second. That seemed to work for me.

This is how I have it coded when I am check start and endtime from DBQL:

     (l.firstresptime - l.starttime HOUR TO SECOND) AS RespTm

Hopefully this will help. I would test it on our 14.10 system, but it is currently down for some maintenance.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020