Arithmetic overflow error converting expression to data type datetime (Int64 to datetime)

Trying

SELECT convert(datetime, 20120825142616 , 120) AS time

Running into exception

Arithmetic overflow error converting expression to data type datetime.

The value '20120825142616 ' is of type 'Int64' passed as parameter to a .Net SqlCommand object.

Any help is appreciated


ANSWERS:


If you place your data in single quote then you will not get arithmetic flow error

SELECT convert(datetime, '20120825142616' , 120) AS [time]

but you will got an error:

Conversion failed when converting date and/or time from character string.

I thought the format is not right. If I only place date it works. like

SELECT convert(datetime, '20120825' , 120) AS [time]
-- output
2012-08-25 00:00:00.000

and If I place date in this format it works

SELECT convert(datetime, '2012-08-25 14:26:16' , 120) AS [time]
-- output
2012-08-25 14:26:16.000


 MORE:


 ? Updating EF model throws ""Arithmetic overflow error converting expression to data type datetime"
 ? Arithmetic overflow error converting expression to data type datetime. in asp.net
 ? SQL Server Arithmetic overflow error converting expression to data type datetime
 ? How to log SqlDataAdapter exceptions asynchronously?
 ? How to log SqlDataAdapter exceptions asynchronously?
 ? How to log SqlDataAdapter exceptions asynchronously?
 ? SqlDataAdapter not update database
 ? multithreading sqldatareader time expired
 ? multithreading sqldatareader time expired
 ? multithreading sqldatareader time expired