SELECT  r1.Report_Day ,
        r1.Report_Hour ,
        r1.report_month ,
        r1.report_year ,
        DATEADD(HOUR, r1.report_hour, CAST(CAST(r1.report_year AS VARCHAR) + '-' + CAST(r1.report_month AS VARCHAR) + '-' + CAST(r1.report_day AS VARCHAR) AS DATETIME)) AS 'NEWDATETIME'