HOW TO CONVERT VARCHAR TO DATE IN SQL SERVER?

Somesh

Total Post:21

Points:147
Posted by  Somesh
 1767  View(s)
Ratings:
Rate this:
Problem in converting varchar to date in sql server?
Give the right solution of its
thanks.
  1. Amit Singh

    Post:103

    Points:721
    Re: How to convert varchar to date in sql server?

    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



Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!