Mysql Extract Zero Date Value

I have a mysql table that has a '0000-00-00 00:00:00' and i'm trying to load a mysql dump using the copy command and getting the Date/time field value out of range: "0000-00-00 00:00:00". How would you suggest approaching this, is anyone aware of an option to mysqldump command or the vertica copy command that will allow this to be null, I was going to use the null option in the vertica copy command and use that string but i'm already using the null option for \N which the mysql uses for nulls in other data types.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file