[Info-ingres] Corrupted timestamp values

Dennis droesler at comcast.net
Fri Jul 24 04:59:23 UTC 2015


Hi,

Copying (copydb -c) data from a 9.2 installation to a 10.2 installation 
tables that have a timestamp column are failing some rows with corrupted 
timestamp values.

The time part of the timestamp have one or more negative values in them. 
  I.e YYYY-MM-DD -5:-1:-3.000000.

Is there a query that can be run to find these?

Dennis



More information about the Info-ingres mailing list