SQL Server - TIMESTAMP caused exception

by Danis Lam   Last Updated June 13, 2019 02:06 AM

I am syncing from PostgreSql to MSSQL using SymmetricDS. Some tables of the source database have timestamp field set too '0001-01-01 00:00:00.0' and it could not be able to insert to destination(SQL Server) database.

Is there anyway to work around this ?

AcknowledgeService - The outgoing batch 001-987 failed: Parameter arg '0001-01-01 00:00:00.0' type: TIMESTAMP caused exception: Only dates between January 1, 1753 and December 31, 9999 are accepted.


Related Questions


Updated February 12, 2018 17:06 PM

Updated September 26, 2018 02:06 AM

Updated June 15, 2019 08:06 AM

Updated March 08, 2018 04:06 AM

Updated October 20, 2018 01:06 AM