Convert INT to DATE in MS SQL Server?

[beckwiga]

I'm trying to convert a date stored as an INT into a DATETIME format. For example, my date is formatted as 20071231 and I want to convert it to a proper DATETIME or SMALLDATETIME. Anyone know how would I go about doing this?

I searched the forum and Google'ed this, but have not had much luck. Any suggestions are much appreciated.

 

[SQLDenis]

select convert(datetime,convert(varchar(8),20071231))

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[beckwiga]

Sweet, thanks Denis.

 

[ESquared]

Denis nailed it (as expected) and FYI the reason this was so easy is that yyyymmdd as in '20071231' is one of the few formats that will always convert to a date properly, no matter what the datefirst/localization settings are.