On 3/22/18, 9:43 AM, "sqlite-users on behalf of R Smith" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of ryansmit...@gmail.com> wrote: > On 2018/03/22 4:22 PM, Peter Da Silva wrote: > > Don't actually need to convert it to datettime if it's already in the right > > format, do you, or does datetime() do some grooming the source needs? > > Yes indeed, it's down to "vetting" and in no way needed for the conversion. > If datetime(x) understand x and doesn't produce any NULLs, then x is a valid > ISO8601 date (or valid-enough for SQLite) and all is fine.
Sure, but should you do that there? Because it won't tell you you had bad data, it'll just lose it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users