question

Assuming the ph_time column is actually the number of minutes after midnight, you might want to do something like this: --======= ================================================================================================= --======= Create 100000 rows of random dates from the next 12 months. DECLARE @mln as datetime = dateadd(dd,datediff(dd,0,getdate()),0); --midnight last night IF OBJECT_ID('tempdb..#dates_and_minutes') IS NOT NULL DROP TABLE #dates_and_minutes; SELECT TOP 100000 dateadd(dd,abs(checksum(newid())) % 365,@mln) as ph_date --create some random dates ,abs(checksum(newid())) % 1440 as ph_time --This might be a misnomer I think. Should it say minutes from midnight? INTO #dates_and_minutes FROM sys.columns t1 CROSS JOIN sys.columns t2 ; --------- I think this next line is what you're really after. SELECT dateadd(mi,dm.ph_time,dm.ph_date) as ph_date_time ,dm.ph_date ,dm.ph_time FROM #dates_and_minutes dm ;