Re: [sqlite] DateTime kind stored as undefined

Hi Cezary, indeed I try your piece of code (to retrieve data) and it works as expected, kind is stored in db. It seems that it is a problem with dapper instead of SqLite. So I will bump issue in Dapper (https://github.com/StackExchange/Dapper/issues/571). Many thanks for help! Best regards,

Re: [sqlite] DateTime kind stored as undefined

Hello, > my connection string looks like this: > *var connection = new SQLiteConnection("DateTimeKind=Utc;Data > Source=:memory:");* > Here is a blog post about it (settig datetimekind in utc for sqlite) on > which I based: >

Re: [sqlite] DateTime kind stored as undefined

I'm sorry -- the following post was sent to a private e-mail by an accident: Hello, On 2017-12-13 12:51, Michał Niegrzybowski wrote: > I have a table which has a column of type DateTime in my code I insert > there an actual UTC Date (which is not the same as my local time). When I > want to

Re: [sqlite] DateTime kind stored as undefined

On 13 Dec 2017, at 11:51am, Michał Niegrzybowski wrote: > I have a table which has a column of type DateTime in my code I insert > there an actual UTC Date (which is not the same as my local time). When I > want to gather previously added record, my record

[sqlite] DateTime kind stored as undefined

Hi All, I encounter a problem with inserting a DateTime.UtcNow to a database, after upgrade from System.Data.SqLite.x64 ver. 1.0.76 to System.Data.SqLite.Core ver. 1.0.106. I have a table which has a column of type DateTime in my code I insert there an actual UTC Date (which is not the same as my