Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Apr 2013 @ 17:35:42 GMT


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


Subj:   Re: Time addition issue
 
From:   Geoffrey Rommel

  You have to add a duration of time to a time, i.e. an INTERVAL.  


Another way to look at it: a TIME is a point (0 dimensions); an interval is a line (1 dimension).

You can:

- find the distance between two points (time - time);

- construct a line beginning at a point (time + or - interval);

- place one line at the end of another (interval + interval);

- find the difference in length of two lines (interval - interval).


You cannot add two points (time + time).



     
  <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