Reported By: Ole Willy Tuv Reported On: 4/5/2007 For: Version 1.02 Build 1
# 2312Subtracting Two Dates as a Milliseconds Interval Can Cause Value Overflow for Result The following SQL statement returns the incorrect value for milliseconds.
select (date'2007-04-05'-date'1970-03-12') msecond "millisecond"
from dummy
Result Correct value
1452095488 1169683200000
CommentsIt is also possible to encounter this issue with SECOND intervals also.
ResolutionFixed Problem on 4/7/2007 in version 1.03 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