Icon View Incident Report

Serious Serious
Reported By: Steve Forbes
Reported On: 2/27/2007
For: Version 1.00 Build 1
# 2244 CASTing 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



Resolution Resolution
Fixed Problem on 2/28/2007 in version 1.01 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