---
title: "How to convert varchar to date in sql server?"  
description: "How to convert varchar to date in sql server?"  
author: "Somesh"  
published: 2011-08-12  
updated: 2011-08-12  
canonical: https://www.mindstick.com/forum/285/how-to-convert-varchar-to-date-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to convert varchar to date in sql server?

[Problem](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic) in converting [varchar](https://www.mindstick.com/forum/161878/what-is-the-difference-between-nvarchar-and-varchar) to [date in sql](https://www.mindstick.com/interview/33841/how-to-add-a-time-interval-in-given-date-in-sql-server) [server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over)?\
Give the [right](https://www.mindstick.com/articles/12766/check-whether-you-are-doing-digital-transformation-right-or-not) solution of its \
thanks.

## Replies

### Reply by Amit Singh

Hi somesh\
check this sample, how to convert varchar to [date](https://yourviews.mindstick.com/story/3869/propose-day-2024-exciting-date-ideas-for-you-and-your-partner) typein [sql server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server)\
\
Declare @val varchar\
declare @d as date=convert(date,'2011/08/07',111)\
select @d\
\
\
\


---

Original Source: https://www.mindstick.com/forum/285/how-to-convert-varchar-to-date-in-sql-server

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