2 ms·
> Offhand, Date types are really strings in SQLite. It’s more that there’s no such thing as a date type, but that date and time functions can work with text or
by chrismorgan 3y ago
> Offhand, Date types are really strings in SQLite.
It’s more that there’s no such thing as a date type, but that date and time functions can work with text or numbers, in a few different interpretations.
Documentation: https://www.sqlite.org/lang_datefunc.html https://www.sqlite.org/lang_datefunc.html.
- chasil 3y agoIf you load the ODBC driver version of SQLite, there is an option to transparently convert the ODBC date time expressions into Oracle style dates. It's an option for those who want easier handling. "When the DSN Option "JDConv" (Julian Day conversion) is enabled the SQLite 3 driver translates floating point column data interpreted as Julian Day to/from SQL_DATE, SQL_TIME, and SQL_TIMESTAMP data types (supported since May 2013)." http://www.ch-werner.de/sqliteodbc/html/index.html http://www.ch-werner.de/sqliteodbc/html/index.html