SQL Server DateTime2 Error
I'm in a process of migrating data from Oracle to Microsoft SQL Server. In
oracle, date range is between '01-01-0001' to '31-12-9999'. I'm using
Pentaho tool to migrate data from Oracle to Microsoft SQLServer. When I
migrate data, it pops error that, "Only dates between January 1, 1753 and
December 31, 9999 are accepted."
To resolve this kind of date issue, I converted "Datetime" data type to
"Datetime2". Even after changing data type, I get the same error of "Only
dates between January 1, 1753 and December 31, 9999 are accepted." I'm
using Pentaho Data Integration to Migrate data.
Any kind of solution?
No comments:
Post a Comment