Using DateTimeFormat=Default on the connection string, DateTime values of UTC kind will be stored with 'Z' appended to properly mark it as UTC. Reading this value will however convert it according to current local timezone, not entire expected since we stored it as UTC. The DateTime.Kind property on the value is NOT set, causing the default value 'Unspecified' to be present.
As an example, '2011-12-15 09:48:53.4628806Z' will be read as '2011-12-15 10:48:53' for me (local timezone: +1) with property Kind=Unspecified. What I would like to see is Kind=Local, or Kind=UTC for that matter in case no time zone conversion was made.
<hr /><i>mistachkin added on 2011-12-18 21:42:39 UTC:</i><br />
Setting the DateTimeKind property of the connection string to Utc will do what you are asking for. For now, the default must remain Unspecified.
<hr /><i>anonymous added on 2011-12-19 09:40:11 UTC:</i><br />
Please consider adding a DateTimeKind property to SQLiteConnectionStringBuilder (hence why I missed it).
<hr /><i>mistachkin added on 2011-12-19 20:00:28 UTC:</i><br />
Ok, I'll do that.
<hr /><i>mistachkin added on 2011-12-20 00:09:42 UTC:</i><br />
Support added as of check-in [4fbdb092f8].
<hr /><i>mistachkin added on 2011-12-20 04:39:35 UTC:</i><br />
Please test these changes in your environment and let me know if they fix the issue for you.
<hr /><i>anonymous added on 2011-12-21 09:31:15 UTC:</i><br />
It's working great! Thanks!