Home > DeveloperSection > Forums > How to convert varchar to date in sql server?
Somesh

Total Post:21

Points:147
Posted on    August-12-2011 2:15 AM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 1551  View(s)
Rate this:
Problem in converting varchar to date in sql server?
Give the right solution of its
thanks.


Amit Singh

Total Post:103

Points:721
Posted on    August-12-2011 5:10 AM

Hi somesh
check this sample, how to convert varchar to date typein sql server

Declare @val  varchar
declare @d as date=convert(date,'2011/08/07',111)
select @d




Don't want to miss updates? Please click the below button!

Follow MindStick