SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of storing dates and times as INTEGER, TEXT or REAL values: INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC. TEXT as ISO8601 strings (“YYYY-MM-DD HH:MM:SS.SSS”).REAL as Julian […]

See our C# page here.