If you send a date time (without timezone specifier) to a SQLite database they will be saved as UTC (not as your local time). The following query corrects this issue.

gistfile1.txt

--- localtime of sqlite MUST be the same with app that sent incorrect touched_date
with param as (
select
	touched_date as v, timediff(datetime(touched_date, 'localtime'), datetime(touched_date)) as delta from <errored-table-name>)
select
	delta,
	datetime(v),
	CASE WHEN SUBSTR(delta, 1, 1) = '+'
	THEN datetime(v, REPLACE(delta, '+', '-'))
	ELSE datetime(v, REPLACE(delta, '-', '+'))
	END
from
	param;