SQL Server Convert Varchar to Datetime

SELECT CONVERT(Datetime, '2017-10-26 18:01:00', 120) -- to convert it to Datetime

SELECT CONVERT( VARCHAR(30), @date ,105) -- italian format [26-10-2017 18:01:00]
+ ' ' + SELECT CONVERT( VARCHAR(30), @date ,108 ) -- full date [with time/minutes/sec]

 Datetime variable has no format. You must convert it to a varchar if you want it to display in a certain format

Or

DECLARE @date DATETIME
SET @date = '2016-10-26 18:01:00'
select convert(varchar, @date,105) + ' ' + convert(varchar, @date,108)

Click on Below Link to go to Microsoft documentation.

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql