Repository navigation
Add support for TEXT_DATETIME #289
Description
For my DB I'm getting:
┌ Warning: Unsupported SQLite declared type TEXT_DATETIME, falling back to String type
└ @ SQLite ~/.julia/packages/SQLite/aDggE/src/SQLite.jl:416
I guess TEXT_DATETIME should be supported by Julia though I can't find it officially mentioned in the documentation:
https://www.sqlite.org/datatype3.html
Activity
quinnj commentedon Apr 9, 2022
Yeah, we're talking about removing the warning since we can't possible cover all possible types since sqlite allows you to put "anything" as the column type (ref #279 )
quinnj commentedon Oct 4, 2026
The warning reported here was removed in #290, included in v1.4.1. I verified registered SQLite.jl 1.9.0 and current master
997c150on Julia 1.9.4 and 1.13.1 with aTEXT_DATETIMEcolumn: inserting and selecting2022-04-09 15:30:00returns the original string without a warning.SQLite permits arbitrary declared type names and has no separate date/time storage class. SQLite.jl falls back to the stored value's type for an unfamiliar declaration;
TEXT_DATETIMEtherefore does not imply an automatic JuliaDateTimeconversion. Applications can parse the returned strings using their chosen date format.Closing the reported warning as resolved. No new special case for this declaration is needed.
AI disclosure: This work was prepared with assistance from OpenAI Codex.