Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 01 Oct 2004 @ 22:15:09 GMT


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


Subj:   Adding two time columns
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, October 01, 2004 18:10 -->

Hi Forum,

I'm new at Teradata and i'm trying to add two time columns.

I tried to do so but i got the next results:

     Column1       Column2      Result
     23:58:43      0:02:29      23:60:72
     23:58:39      0:01:06      23:59:45
     23:57:56      0:00:33      23:57:89
     23:57:14      0:00:38      23:57:52
     23:57:03      0:00:25      23:57:28
     23:56:44      0:00:28      23:56:72

As you can see, only sometimes the result is good.

I'll appreciate the help you could give me.


Thanks



     
  <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: 27 Dec 2016