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: 24 Jul 2020