On 3/22/18, 9:22 AM, "sqlite-users on behalf of Ron Watkins" <[email protected] on behalf of [email protected]> wrote: > Is there an easy way to "fix" the data already in the table?
The string trim trick David and Ryan suggested would work. To avoid banging on rows already converted, maybe: UPDATE foo SET dttm = trim(dttm,'''') WHERE dttm like '''%'''; Note that's 4 single quotes in the first string, and two sets of three single quotes in the second. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
