Archives of the TeradataForum
Message Posted: Fri, 02 Jul 2004 @ 13:46:51 GMT
| Subj: || || Re: Aiii, INTERVALs! |
| From: || || Victor Sokovin |
| ||Consider the following SELECT,|| |
SELECT TIMESTAMP '2004-06-15 23:59:60.000000' A
,TIMESTAMP '2004-06-16 00:00:00.000000' B
WHERE A = B;
| ||This statement returns 0 rows. Is this correct? For me, this presents a problem loading data from multiple source systems that send
differently formatted timestamps.|| |
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
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. I am not sure they are known in advance so the DB has to accept
them. There should be a thread on this in the archives with a useful URL.