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!!
'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!!