View Incident Report

Serious

Reported By: Hedley Muscroft
Reported On: 2/18/2009
For: Version 2.02 Build 7

# 2926 CAST Function Returns Incorrect Results When Casting Date and TimeStamp Values to Strings

Using the following SQL, EDB Manager works fine and returns :-

1011208090258546403 | Appt on 2008-12-01 16:00 [Lastname, Nick] | 2008-12-01 04:00 PM

In ADO.NET we get:

1011208090258546403 | Appt on Elevate.ElevateDB.Data.Engine.TEDBParsedDate 16:00 [Lastname, Nick] | 2008-12-01 04:00 PM

Looks like the DATE part isn't being converted properly in the EDB ADO.NET provider.

select app.id,
('Appt on ' || cast(start as varchar(20)) || ' [' || per.lastname || ', ' || 
per.firstname || ']') as description, start
from app
join per on (app.per_id=per.id)

Comments

The issue was a ToString call on the wrong object instance.

Resolution

Fixed Problem on 2/18/2009 in version 2.02 build 8

Products Affected

ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap