DECLARE @fromdate Date DECLARE @ShiftStart varchar(60)='09:00' select @fromdate=CONVERT(VARCHAR(10),'2014-12-16 10:18:00.000',101) SELECT CAST(@fromdate AS DATETIME) + CAST(@ShiftStart AS DATETIME)
SELECT CAST((CAST(your_date_column AS DATE) AS DATETIME) + CAST(your_time_column AS TIME)) as Datetime) FROM your_table
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)