Articles → SQL SERVER → Parse Function Of The SQL Server

Parse Function Of The SQL Server

In this article, we will discuss the Parse function of the SQL server.

Purpose

The Parse function converts the string data to the requested data type.

Syntax

parse([value] As [Data Type])

Example

In this example, we will convert string data to the datetime datatype.

declare @str as nvarchar(20) = '12/12/2023'
Declare @date as datetime
set @date = parse(@str as datetime)

select @date As [Date]

Output

Click to Enlarge

Try_Parse Function

Like the Parse function, the try_parse function converts the string data to the requested data type. The difference is that the Parse function throws an error if the conversion is not possible. Whereas the try_parse function returns null if the conversion is not possible.

Posted By -	Karan Gupta

Posted On -	Monday, August 28, 2023

Updated On -	Sunday, September 3, 2023

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**