Thomas Levesque • 6/28/2015

How to retrieve dates as UTC in SQLite

This technical article addresses a common issue in SQLite with the ADO.NET provider where UTC dates are incorrectly converted to local time upon retrieval. It demonstrates the problem with code examples and provides the solution: adding 'DateTimeKind=Utc' to the connection string to preserve the DateTime.Kind property. A caveat about applying this setting only when all dates are stored as UTC is included.

0 comments

#sqlite #connection string #datetime