 |
 |
Archives of the TeradataForum
Message Posted: Wed, 18 May 2005 @ 12:15:19 GMT
| Subj: | | Re: Calculate TIMESTAMP difference |
| |
| From: | | Victor Sokovin |
| | As you can see, the purpose of DELETE clause is to delete the row which is more than 30 seconds old. | |
| | For some reason, I get a compile error in DELETE statement. | |
The reason might be in the fact that the two intervals you compare are of different types. It could be hard to compare them directly with the
current state of timestamp and interval technology.
www.teradataforum.com/l030515a.htm
explains how to calculate the difference between two timestamps in good old seconds.
Regards,
Victor
| |
