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.