I have a filed with VarChar in my table , I want to convert it in DateTime.. thanks
Convert VarChar to DataTime Anonymous User 2831 09 Oct 2010 I have a filed with VarChar in my table , I want to convert it in DateTime..thanks
declare @s varchar(50)
set @s = '2018-06-28 11:01:00'
select convert(varchar, cast(@s as datetime), 105) + RIGHT(@s, 9)
SELECT convert(datetime, '1/12/2010', 212) -- mm/dd/yyyy
SELECT convert(datetime, '2010.1.12', 214) -- yyyy.mm.dd
cheers!