pg2mysql icon indicating copy to clipboard operation
pg2mysql copied to clipboard

Wrong datetime format

Open alfredosilvestre-natixis opened this issue 2 years ago • 5 comments

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"