How to create datetime from date and string in tsql

Question

I have a Store Procedure in T-SQL. I want to create a datetime from date and string.

So I have this:

DECLARE @DATE AS DATE
DECLARE @TIME AS NVARCHAR(5)

SET @DATE = NOW() /*2017-10-11*/
SET @TIME = '08:00'

Now, I want to create this date '2017-10-11 08:00:00'

Answer 1

You are looking something like :

DECLARE @DATE AS DATE
DECLARE @TIME AS NVARCHAR(5)

SET @DATE = GETDATE() /*2017-10-11*/
SET @TIME = '08:00'

SELECT CONVERT(DATETIME, CONVERT(VARCHAR, @DATE) + ' '+ CONVERT(VARCHAR, @TIME))

Output :

2017-10-11 08:00:00.000