I was just using the ;DateTimeKind= DateTimeKind.Utc But I just tested without any date settings and it works also.
I have not tried your new method. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Thursday, May 30, 2013 9:45 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] .net Sqlite lib reading date fields not working? eschneider FE > > Solved it. > Great. I'm curious, which connection string properties did you end up using? > > You cannot use parameter DbType.DateTime2 and must use DbType.DateTime for > the lib to format the date upon insert. > Right, DbType.DateTime2 is not recognized by System.Data.SQLite. -- 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