Just realized I left in the work around code, the date issue is still a problem.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of eschneider FE Sent: Wednesday, May 29, 2013 6:26 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] .net Sqlite lib reading date fields not working? The default is a non-working default though. So inserting using best practices of SQL statement & parameters does not work, and queries also. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Wednesday, May 29, 2013 6:13 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] .net Sqlite lib reading date fields not working? eschneider FE wrote: > > Ok; re-reading last and saw connection string. So adding ;DateTimeKind= > DateTimeKind.Utc to connection string works. Why isn't this the default? > Primarily because making it the default would alter the behavior in a very subtle and non-backward compatible way. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
