| Ticket Hash: | c6397ed60e34a015a052892aa6ce7bd94366278a | |||
| Title: | The string was not recognized as a valid DateTime at timestamp | |||
| Status: | Closed | Type: | Incident | |
| Severity: | Important | Priority: | Medium | |
| Subsystem: | Convert | Resolution: | Works_As_Designed | |
| Last Modified: | 2020-10-29 02:35:38 | |||
| Version Found In: | 1.0.112 | |||
| User Comments: | ||||
|
anonymous added on 2020-04-24 13:31:04:
By reading from a table with column with TIMESTAMP (byte[] 8 bytes) the program throws the error "The string was not recognized as a valid DateTime" All in this Project: https://cloud.webnworkls.selfhost.eu/s/qsSMFCX3FJ5aNyg ConsoleSqLiteTest.zip Table SQL CREATE TABLE Artikel ( ARTIKEL_ID VARCHAR(50) PRIMARY KEY NOT NULL, TEXT VARCHAR(50), time TIMESTAMP ) Steps to reproduce Unzip in Windows with Visual Studio 2017 Pro Further technical details Version 4.7.670.0 - 1.576.065 downloads SQL Server Compact 4.0 in GAC - No SQL Server Compact 4.0 DbProvider - No SQL Server Compact 4.0 DDEX provider - No SQL Server Compact 4.0 Simple DDEX provider - Yes SQL Server Compact 3.5 in GAC - No SQL Server Compact 3.5 DbProvider - No SQL Server Compact 3.5 DDEX provider - No Sync Framework 2.1 SqlCe 3.5 provider - No SQLite ADO.NET Provider included: 1.0.112.0 SQLite EF6 DbProvider in GAC - Yes System.Data.SQLite DDEX provider - No SQLite Simple DDEX provider - Yes mistachkin added on 2020-04-25 14:00:21: Offhand, I'm not sure that System.Data.SQLite supports extracting a DateTime value from a byte array. Generally, DateTime values are converted from Int64 (number of ticks since the epoch), Julian day numbers (Double), or a String in one of the supported formats. anonymous added on 2020-05-20 12:57:18: It would have helped me if I knew how to get the data, timestamp binary array, without converting it. mistachkin added on 2020-10-29 02:35:38: This type of value conversion is not supported by System.Data.SQLite. | ||||
