Re: [sqlite] DateTime kind stored as undefined

2017-12-21 Thread mnie
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, Micha

Re: [sqlite] DateTime kind stored as undefined

2017-12-16 Thread Cezary H. Noweta
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: > https://www.thomaslevesque.com/2015/06/28/how-to-retrieve-dates-as-utc

Re: [sqlite] DateTime kind stored as undefined

2017-12-14 Thread Cezary H. Noweta
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 gath

Re: [sqlite] DateTime kind stored as undefined

2017-12-13 Thread Simon Slavin
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 contains date in his > DateTime colum

[sqlite] DateTime kind stored as undefined

2017-12-13 Thread Michał Niegrzybowski
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