Problem in converting varchar to date in sql server?
Give the right solution of its
thanks.
How to convert varchar to date in sql server?
3065
12-Aug-2011
Updated on 12-Aug-2011
Amit Singh
12-Aug-2011check 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