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.


KRT



     
  <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: 23 Jun 2019