I'm currently importing a table from MYSQL to MSSQL. There's a column there for storing date, only it's stored as an number. When i import it to MSSQL i get it in as an int data type.
When i try to convert that to datetime I get an :
Arithmetic overflow error converting expression to data type datetime.
Since i'm using MSSQL 2005 I can't use datetime2 and fit it so it does not overflow.
Is there a way to trim that date stored as an int so it does not overflow the datetime format ?