 |
 |
Archives of the TeradataForum
Message Posted: Wed, 07 Jul 2004 @ 13:15:04 GMT
| Subj: | | Re: Aiii, INTERVALs! |
| |
| From: | | Geoffrey Rommel |
| | Doesn't it have to do with the fact that 61 second in a timestamp can sometimes be a valid value (used in astronomical corrections
etc)? | |
| | SELECT TIMESTAMP '2004-06-15 23:59:61.000000' seems to be a valid timestamp. | |
| | Perhaps the database has to be careful about such astronomical corrections. | |
Yes, this is for leap seconds. Googling for "leap second" will produce an astronomical (get it?) number of references such as this:
tycho.usno.navy.mil/leapsec.html
| |
