Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Casting TIMESTAMP to VARCHAR bug in ADO.NET |
Wed, Feb 18 2009 7:02 AM | Permanent Link |
"Hedley Muscroft" | Using my test database :-
http://files.pioneersoftware.co.uk/temp/edb_testdb.7z Here's the SQL :- ---------------------- 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) ---------------------- EDB Manager works fine and returns :- 1011208090258546403 | Appt on 2008-12-01 16:00 [Lastname, Nick] | 2008-12-01 04:00 PM etc. 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. Thanks! |
Wed, Feb 18 2009 8:37 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Hedley,
<< In ADO.NET we get :- 1011208090258546403 | Appt on Elevate.ElevateDB.Data.Engine.TEDBParsedDate 16:00 [Lastname, Nick] | 2008-12-01 04:00 PM >> Got it, thanks. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |