On 22 Mar 2018, at 14:05, Ron Watkins <rwa...@gmail.com> wrote: > The file that I use ".import" on contains records like this:
> '2018-03-22 07:01:01'|2533268 > I had assumed the value was being treated as a datetime, but it looks like it > may be treated as a string? > > Im a bit confused because the column definition sais "datetime", not > "varchar", so if it's being treated as a string what can I do to fix it to be > treated as a actual datetime datatype? SQLite has no DATETIME or BOOLEAN datatype, see: <http://www.sqlite.org/datatype3.html> Personally I store all date/times as seconds since the epoch; it simplifies life a lot. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users