Loading

How to concatenate date and time in sql server 2005?

Nirmal KumarC

11y1.6k

Sql server 2008 Concatenate successful Running but Sql server 2005 Not Concatenate ,
This Below Query.

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)

The Above query wise how to concatenate(date and time)in sql server 2005.

I want concatenate(date and time) Result is 2014-12-16 09:00:00.000.

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manish Kumar Choudhary11y ago
try it
DECLARE @t AS time='09:00'

DECLARE @d AS date=CONVERT(VARCHAR(10),'2014-12-16 10:18:00.000',101)

DECLARE @dt as datetime

SET @dt = @d+cast(@t as datetime)

select @dt