Sponsored By
MindStick SurveyManager
Advertise with Us
Advertisement
Advertise with Us
Follow Us
Follow _MindStick_ on Twitter View MindStick Software's LinkedIn profile View MindStick Software's Facebook profile
Mindstick
Article Article  Forum Forum  Blog Blog  Quiz Quiz  Beginner Beginner  Careers Careers  Contact Contact  Login Login  
Home | Product | Services | About Us | Interview | DeveloperSection | Submit an Article | Submit Blog
Report Abuse Form
Reason:    
   

Home >> Database >> MSSQL Server 2000/2005/2008/2012 >> How to convert varchar to date in sql server?
Author Post

Somesh


Total Post: 21
Member Since: 10/26/2010
Points: 107
How to convert varchar to date in sql server?
Posted On: 8/12/2011 2:15:40 AM
Problem in converting varchar to date in sql server?
Give the right solution of its
thanks.
Modified On: 8/12/2011 4:52:27 AM
Author Post

Amit Singh


Total Post: 104
Member Since: 8/8/2010
Points: 702
Re: How to convert varchar to date in sql server?
Posted On: 8/12/2011 5:10:42 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



Report Abuse Form
Reason:    
 
Total Online Users: 7051
Advertisement
MindStick DataConverter
Advertise with Us
  
Copyright © 2009 - 2013MindStick. All Rights Reserved.