Reported By: Ole Willy Tuv Reported On: 4/12/2007 For: Version 1.02 Build 1
# 2324Casting a TIMESTAMP Value to a TIME Value Results in a Compilation Error The following SQL results in the error:
ElevateDB Error #700 An error was found in the statement at line 3 and column 26 (Expected Char, VarChar, Byte, VarByte or Time expression but instead found CURRENT_TIMESTAMP())
select castcurrent_timestampp as date),
castcurrent_timestampp as time)
from dummy
ResolutionFixed Problem on 4/14/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