Convert INT YYYYMMDD to date mm/dd/yyyy

I can't seem to find a way to convert an INT type in the form of YYYYMMDD to
an actual date form of mm/dd/yyyy

Can anyone pointt me in the right direction?

Thanks

Re: Convert INT YYYYMMDD to date mm/dd/yyyy

Hi there,

The easiest way to achieve your goal is to convert your INT into an
eight character long string first, and then convert your string in the
datetime format.
As an example : SELECT CONVERT(DATETIME, CONVERT(CHAR(8), 20070824))

Elsewhere, it is a bit complicated, as the DateTime format is based on
the difference in days from 1900/01/01. Thus, you have to use a quite
heavy function as leap years are not regular. All the functions I
tried have bad performance compared to the double conversion.

Enjoy,

C=E9dric Del Nibbio
MCT
MCDBA SQL Server 2000
MCITP Database Administrator SQL Server 2005
MCSD .NET
http://cedric-delnibbio-sql.blogspot.com

On 24 ao=FBt, 00:41, "rdraider" wrote:
> I can't seem to find a way to convert an INT type in the form of YYYYMMDD=
to
> an actual date form of mm/dd/yyyy
>
> Can anyone pointt me in the right direction?
>
> Thanks