INSERT INTO JHI_USER(ID, LOGIN, PASSWD, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, ACTIVATION_KEY, RESET_KEY, PASSWORDPERIOD, PASSWORDCHANGEDDATE, FORCETOCHANGEPASSWORD, CREATED_BY, CREATED_DATE, RESET_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE)
VALUES(32, '85757', '$2auuuuuuuuuuu', '林XX', '林XX', NULL, 1, 'zh-tw', NULL, 'true', NULL, NULL, 0, 'system', TO_TIMESTAMP('2017-06-22 09:11:04:9000000','YYYY-MM-DD HH24:MI:SS:FF'), NULL, 'system', TO_TIMESTAMP('2017-08-31 09:06:58:612000000','YYYY-MM-DD HH24:MI:SS:FF'))
GO
Mysql
INSERT INTO JHI_USER(ID, LOGIN, PASSWD, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, ACTIVATION_KEY, RESET_KEY, PASSWORDPERIOD, PASSWORDCHANGEDDATE, FORCETOCHANGEPASSWORD, CREATED_BY, CREATED_DATE, RESET_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE)
VALUES(32, '85757', '$2auuuuuuuuuuu', '林XX', '林XX', NULL, 1, 'zh-tw', NULL, 'true', NULL, NULL, 0, 'system', STR_TO_DATE('2017-06-22 09:11:04:612000','%Y-%m-%d %H:%i:%s:%f'), NULL, 'system', STR_TO_DATE('2017-08-31 09:06:58:612000','%Y-%m-%d %H:%i:%s:%f'));
利用Notepad++ Regular Expression gular Expression 取代功能
Find what: :[0-9]+','YYYY-MM-DD HH24:MI:SS:FF'\)
Replace with: :612000','%Y-%m-%d %H:%i:%s:%f'\)
同時另外將 TO_TIMESTAMP 取代為 STR_TO_DATE
