Arithmetic overflow error converting expression to data type datetime.

[luvmy2Js]

Could someone please help me figure out how to convert the below data:

'19731214' is how the date is printed from the database.

I have tried:

1. CONVERT(varchar, CONVERT(datetime, CONVERT(nvarchar, DecryptByKey(a.[Birth Day])), 101), 101)

But it returns the "Arithmetic overflow..." error.

Any suggestions would be greatly appreciated.

Thanks!!

 

[bborissov]

What you get from:

SELECT DecryptByKey(a.[Birth Day])

?


Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[luvmy2Js]

All data is encrypted in the database so it has to be decrypted when extracting it out..

 

[SQLBill]

Try setting the length of VARCHAR and NVARCHAR.

For example; VARCHAR(8).

The other thing to do is check what your DATEFORMAT setting is. You are trying to read yyyymmdd and change it to mm/dd/yy. If your DATEFORMAT isn't YMD then it will read the value incorrectly.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875