pg2mysql
pg2mysql copied to clipboard
Wrong datetime format
On some datetime values that are exported we have the following error:
ERROR 1292 (22007) at line 677: Incorrect datetime value: '2022-01-31 16:18:56+01'
Right now we are using sed to replace:
sed -i -e 's/\+[[:digit:]]\{2\}//gi' "${MYSQL_DUMP}.sql"