• Something like this...

    DECLARE @DateAsInt INT = 20170625;

    SELECT
        DateAsDate = DATEFROMPARTS(SUBSTRING(dc.DateAsChar, 1, 4), SUBSTRING(dc.DateAsChar, 5, 2), SUBSTRING(dc.DateAsChar, 7, 2))
    FROM
        ( VALUES (CAST(@DateAsInt AS CHAR(8))) ) dc (DateAsChar);