Numeric to Date conversion in SQl Server 2000

Question

Folks,

Iam facing a problem in sql server 2000. I unable to convert numeric value to date format using CONVERT and CAST keyword in sql server 2000. I tried with below mentioned example.

declare @a NUMERIC(10) 

set @a=20110101 

select CAST(@a as datetime) as result 

But i am getting an error as "Arithmetic overflow error converting expression to data type datetime"

So, can anyone please help me out..?

Answer 1

Please repost your question in Microsoft's dedicated SQL Server forums here:

http://social.technet.microsoft.com/Forums/en-us/category/sqlserver  .

Thanks.