Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Anonymous User

Other

I am a content writter !

2 Answers

Prakash nidhi Verma 27 Jun 2018

declare @s varchar(50)

set @s = '2018-06-28 11:01:00'

select convert(varchar, cast(@s as datetime), 105) + RIGHT(@s, 9)

Uttam Misra 09 Oct 2010

try this..
SELECT convert(datetime, '1/12/2010', 212) -- mm/dd/yyyy
SELECT convert(datetime, '2010.1.12', 214) -- yyyy.mm.dd
cheers!

advertising