SQL Server Convert Varchar to Datetime
SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- to convert it to DatetimeSELECT CONVERT( VARCHAR(30), @date ,105) -- italian format [28-09-2011 18:01:00]+ ' ' + SELECT CONVERT( VARCHAR(30), @date ,108 ) -- full date [with time/minutes/sec]
Like this
DECLARE @date DATETIMESET @date = '2011-09-28 18:01:00'select convert(varchar, @date,105) + ' ' + convert(varchar, @date,108)