System.Data.SQLite

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

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.

It would have helped me if I knew how to get the data, timestamp binary array, without converting it.

This type of value conversion is not supported by System.Data.SQLite.