Didn't see Lynn's code before I wrote the example, almost the same but without a string thingy

😎

/*Converting INT date and time to datetime */

DECLARE @INT_YYYYMMDD INT = 20140704;

DECLARE @INT_HHMMSS INT = 012056;

SELECT DATEADD(SECOND,

(((@INT_HHMMSS / 10000) * 3600) -- hours to seconds

+ (((@INT_HHMMSS / 100) % 100) * 60) -- minutes to seconds

+ (@INT_HHMMSS % 100)) -- seconds

, CONVERT(DATETIME2(0),CAST(@INT_YYYYMMDD AS VARCHAR(8)),112))

Results

2014-07-04 01:20:56