SQL Server function to convert integer date to datetime format

The above query yields the following results: As you can see, run_date is stored in the format of YYYYMMDD. It is stored as an integer format, not as a string as is the root format underlying the datetime data type within Microsoft SQL Server. I suspect i

www.mssqltips.com