Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 4/5/2007
For: Version 1.02 Build 1
# 2312 Subtracting 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



Comments Comments
It is also possible to encounter this issue with SECOND intervals also.


Resolution Resolution
Fixed Problem on 4/7/2007 in version 1.03 build 1


Products Affected Products Affected
ElevateDB 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

Image