Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Apr 2004 @ 15:28:39 GMT


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


Subj:   Re: Why does teradata accept 61.999999 seconds as the max value in time stamp
 
From:   Dennis Calkins

Because every once in a while scientists adjust the clock by adding a leap second.

from www.tycho.usno.navy.mil...


In order to keep the cumulative difference in UT1-UTC less than 0.9 seconds, a leap second is added to the atomic time to decrease the difference between the two. This leap second can be either positive or negative depending on the Earth's rotation. Since the first leap second in 1972, all leap seconds have been positive and there were 22 leap seconds in the 27 years to January, 1999. This pattern reflects the general slowing trend of the Earth due to tidal braking.



     
  <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