I am pulling my hair out of this error that I keep getting. I have a stored procedure that gets data from a database, with one of those fields being a NVARCHAR(10) which contains information on a date (10/01/2004 etc etc). In this stored procedure I am also pushing all these extracted data into a new database, but in this new database the field that is to contain the date is now a DATETIME field whose length is set to 8.
WHen I try to put the NVARCHAR data into this DATETIME field I get the following error message.
The data in the nvarchar column is all like a normal data, so I was under the impression that this date would automatically convert to DATETIME when passing into the new database
Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.