System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
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: (text/x-markdown)
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: (text/x-fossil-plain)
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: (text/x-markdown)
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: (text/x-fossil-plain)
This type of value conversion is not supported by System.Data.SQLite.