---
title: "Convert VarChar to DataTime"  
description: "Convert VarChar to DataTime"  
author: "Anonymous User"  
published: 2010-10-09  
updated: 2018-06-27  
canonical: https://www.mindstick.com/forum/31/convert-varchar-to-datatime  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Convert VarChar to DataTime

I have a filed with [VarChar](https://www.mindstick.com/forum/161878/what-is-the-difference-between-nvarchar-and-varchar) in my [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) , I want to [convert](https://www.mindstick.com/forum/2093/configurationmanager-appsettings-convert-n-to-n-why) it in DateTime..\
\
thanks\

## Replies

### Reply by Prakash nidhi Verma

declare @s varchar(50)

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

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

### Reply by Uttam Misra

try this..\
**SELECT convert(datetime, '1/12/2010', 212) -- mm/dd/yyyy**\
\
**SELECT convert(datetime, '2010.1.12', 214) -- yyyy.mm.dd**\
\
\
cheers! ![Convert VarChar to DataTime](https://www.mindstick.com/app_images/htmleditor.icons/msp_thumbup.gif)\


---

Original Source: https://www.mindstick.com/forum/31/convert-varchar-to-datatime

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.