你好像在用 STR_TO_DATE() 不正确。这应该有效:
STR_TO_DATE()
INSERT INTO target ( identification, LastModified ) SELECT identification, Str_to_date(LastModified, "%c/%e/%Y %l:%i:%s %p") AS LastModified FROM source;
请注意格式字符串: "%c/%e/%Y %l:%i:%s %p"
"%c/%e/%Y %l:%i:%s %p"