Trying 2 Convert 20060703 to datetime...Im Getting an Error

[jojo79]

I keep getting the following error.

Server: Msg 8115, Level 16, State 2, Line 3
Arithmetic overflow error converting expression to data type datetime.

DECLARE @i int
SELECT @i = 20060703
SELECT convert(varchar, convert(datetime, @i), 101) AS "Formatted Int"

 

[gmmastros]

Try converting to varchar instead.

DECLARE @i [!]varchar(8)[/!]
SELECT @i = [!]'[/!]20060703[!]'[/!]

SELECT convert(varchar, convert(datetime, @i), 101) AS "Formatted Int"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom