Reported By: Steve Forbes Reported On: 2/27/2007 For: Version 1.00 Build 1
# 2244CASTing a TIMESTAMP Value to a VARCHAR or CHAR Value Results in Incorrect Value The following SQL statement results in a scrambled timestamp value representation as a string.
SELECT CAST(Timestamp1 AS VARCHAR(20)) FROM MyTable
ResolutionFixed Problem on 2/28/2007 in version 1.01 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