Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 8/23/2009
For: Version 2.02 Build 15
# 3060 Subtracting a DATE from a TIMESTAMP Column Results in a NULL Value

The following query returns a NULL value.

select _timestamp,
(_timestamp - current_date) day
from eln
order by _timestamp



Resolution Resolution
Fixed Problem on 8/24/2009 in version 2.03 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image