| Ticket Hash: | bb4b04d4578f017ea01ef094a2177687566f7bba | ||
| Title: | Using DateTimeFormat=Ticks with TIMESTAMP column causes exception | ||
| Status: | Closed | Type: | Feature_Request |
| Severity: | Important | Priority: | Medium |
| Subsystem: | Db_Type_Conversion | Resolution: | Fixed |
| Last Modified: | 2013-01-01 19:32:26 | ||
| Version Found In: | 1.0.76,1.0.77 | ||
| Description: | ||||
|
I have database with table like this
CREATE TABLE Times (Time TIMESTAMP NOT NULL)
In connection string I have the option datetimeformat=Ticks
When reading field Times with SQLiteDataReader and trying to convert it in into DateTime type, exception "Invalid typecast" is thrown because returned value has "long" type. In version 1.0.74 and earlier the type was correct - DateTime.
If I'll change declaration of field in database to DATETIME, then all go OK.
Example code http://pastebin.com/aQjUe1tV When linked to 1.0.74 it shows the correct date, but when linked to 1.0.76+, program closes with exception mistachkin added on 2011-11-29 22:33:31 UTC: mistachkin added on 2011-11-30 00:36:19 UTC: | ||||