|
|
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.
www.webstore.ansi.org...
But I don't feel like spending $18 to find out what it says, so I shall remain in ignorance.
--wgr
| |