Archives of the TeradataForum
Message Posted: Tue, 26 Mar 2003 @ 01:06:33 GMT
Could you give a real example:
For example tblXYZ is the table, BEGIN_TIME is the smaller timestamp and END_TIME is the larger timestamp, the following gave me inaccurate results.
SELECT minute(END_TIME - BEGIN_TIME)
I want the total difference in minutes sometimes and total difference in seconds sometimes.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|