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?
On 3/22/18, 9:19 AM, "sqlite-users on behalf of David Raymond" <[email protected] on behalf of [email protected]> wrote: Use datetime there instead of date or you'll lose the time part of it. UPDATE foo SET dttm = datetime(trim(dttm,'''')); _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
