 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Jan 2005 @ 19:07:10 GMT
| Subj: | | Re: Interval Overflow Error |
| |
| From: | | Victor Sokovin |
| | No. That was a brain blip. I tested the algorithm in Perl first; then, when converting to SQL, I forgot that I could just subtract the
dates. I can count on Dieter to keep me on my toes. | |
I am sure we all can.
Thanks for the confirmation. The algorithm can be useful for customers who wish to be really precise about their timestamps. Things like leap
seconds, summer/winter time, etc, can be included in your formula easier than with the standard calculation. Thanks for posting it.
Victor
| |
