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"
<sqlite-users-boun...@mailinglists.sqlite.org on behalf of
david.raym...@tomtom.com> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
