Search code examples
.netsqlitedatetimefluent-nhibernate

Does Sqlite DATETIME Type store timezone information?

I am currently using Fluent-NHibernate with .NET to manage my database objects. When I debug my code in C# the datetime contains a timezone. The datetime string looks like the following:

Calling date.ToString("O") yields the string "2016-05-30T17:33:00.0000000Z"

When I look in the sqlite database the timezone information seems to be missing. Also when I receive the object from the database and debug, I get the following string:

Calling date date.ToString("O") yields the string "2016-05-30T17:33:00.0000000"

Any clarification regarding sqlite datetime types would be appriciated.

Solution

  • SQLite does not have a DATETIME type.

    Dates and types can be stored in several types, but the formats understood by the built-in date/time functions do not have a time zone.