Reported By: Roy Lambert Reported On: 8/23/2009 For: Version 2.02 Build 15
# 3060Subtracting 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
ResolutionFixed Problem on 8/24/2009 in version 2.03 build 1
Products AffectedElevateDB 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