DATE()无法理解您的旧日期格式.

DATE() doesn't understand your old date format.

以下应能工作:

UPDATE tblname SET thedate = substr(thedate, 7, 4) || '-' || substr(thedate, 1, 2) || '-' || substr(thedate, 4, 2);