Archives of the TeradataForum
Message Posted: Tue, 09 Apr 2002 @ 12:57:55 GMT
| Subj: || || Re: TimeStamp subtraction |
| From: || || Geoffrey Rommel |
| ||In trying to understand why/how the SQL from Kent works, ...|| |
| ||When we do 'datetime - datetime' the result is a type INTERVAL. Now it gets confusing....|| |
For me, it got confusing a long time ago. :-) But seriously, all this is ANSI, so I think the only way to make sense out of all
this would be to look at the ANSI SQL specification.
But I don't feel like spending $18 to find out what it says, so I shall remain in ignorance.