Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Oct 2004 @ 03:51:39 GMT


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


Subj:   Re: Adding two time columns
 
From:   Michael Larkins

You cannot add or anything else with TIME or CURRENT_TIME. For instance, it makes no sense to add 2am to 2pm. Instead, you need to define the INTERVAL that you want as HOUR TO SECOND. Then you can add the two intervals to get an answer of the combined amount of time. Therefore, 2 hours plus 2 hours equals 4 hours.

Hope this helps,


Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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: 15 Jun 2023