enum SQLiteDateFormats







This implementation of SQLite for ADO.NET can process date/time fields in databases in one of six formats. 

ISO8601 format is more compatible, readable, fully-processable, but less accurate as it does not 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.

UnixEpoch is more compatible with Unix systems.

InvariantCulture allows the configured format for the invariant culture format to be used and is human readable.

CurrentCulture allows the configured format for the current culture to be used and is also human readable.


The preferred order of choosing a DateTime format is JulianDay, ISO8601, and then Ticks. Ticks is mainly present for legacy code support.


Member Name Description
Ticks                     Use the value of DateTime.Ticks. This value is not recommended and is not well supported with LINQ.
ISO8601                Use the ISO-8601 format. Uses the "yyyy-MM-dd HH:mm:ss.FFFFFFFK" format for UTC DateTime values and "yyyy-MM-dd HH:mm:ss.FFFFFFF" format for local DateTime values).
JulianDay               The interval of time in days and fractions of a day since January 1, 4713 BC.
UnixEpoch             The whole number of seconds since the Unix epoch (January 1, 1970).
InvariantCulture      Any culture-independent string value that the .NET Framework can interpret as a valid DateTime.
CurrentCulture        Any string value that the .NET Framework can interpret as a valid DateTime using the current culture.
Default                   The default format for this provider.


posted @ 2014-11-18 14:41  ChuckLu  阅读(297)  评论(0编辑  收藏  举报