This implementation of SQLite for ADO.NET can process date/time fields in databases in only one of three formats. Ticks, ISO8601
and JulianDay.
Syntax
public enum SQLiteDateFormats
Remarks
ISO8601 is more compatible, readable, fully-processable, but less accurate as it doesn't provide time down to fractions of a second.
JulianDay is the numeric format the SQLite uses internally and is arguably the most compatible with 3rd party tools. It is
not readable as text without post-processing.
Ticks less compatible with 3rd party tools that query the database, and renders the DateTime field unreadable as text without post-processing.
The preferred order of choosing a datetime format is JulianDay, ISO8601, and then Ticks. Ticks is mainly present for legacy
code support.
Members
Member Name
Description
ISO8601
The default format for this provider.
JulianDay
JulianDay format, which is what SQLite uses internally
Ticks
Using ticks is not recommended and is not well supported with LINQ.
Requirements
Namespace: Mono.Data.Sqlite Assembly: Mono.Data.Sqlite (in Mono.Data.Sqlite.dll) Assembly Versions: 4.0.0.0