Reported By: Steve Forbes Reported On: 2/27/2007 For: Version 1.00 Build 1
# 2245Subtracting Two TimeStamp Values Results in an Incorrect Value When I run the following SQL, the result is that all values are large negative values (e.g.-913228448) indicating a numeric overflow perhaps.
SELECT (FinishTime - StartTime) AS Duration FROM Calculated;
ResolutionFixed Problem on 3/1/2007 in version 1.01 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial