Converting NVARCHAR to datetime Problem

[Tryst]

Hi all,

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.

Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.

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

Tryst

[r937]

you really should show the code

we cannot guess what you mean by "put" the NVARCHAR data into the DATETIME field

do you use the CONVERT function?

[markchivs]

Is there any particular reason why your using an NVARCHAR data type to store your date? Especially if your dates are stored as xx/xx/xxxx - Just curious

do you use the CONVERT function?

Yeah it's a good bet you need to use it: