Function to Convert String to Date in SQL Server

The SQL Server has inbuilt function to convert string to date. It can be done using CAST/CONVERT as shown below

DECLARE @stringdate varchar(100),
@cast_dt datetime,
@conver_dt datetime
SET @stringdate='09/25/2014'

SET @cast_dt=CAST(@stringdate AS datetime) 
SET @conver_dt=CONVERT(datetime, @stringdate, 110) 
	@stringdate As Date_as_String,
	@cast_dt AS cast_string_to_date,
	@conver_dt AS convert_string_to_Date

sql server function to convert string to date


There are other formats available in convert function. To get more detail refer to


Like us on FaceBook Join the fastest growing SQL Server group on FaceBook


Leave a Reply

Your email address will not be published.