TRY PARSE Function

When we deal with databases, we have different data types. In SQL Server, we have various data types to store different types of data. Like int data type for integers, varchar data type for strings, date data type for storing the data, and XML for XML type data.

For such types of data conversions, we have several functions provided by the SQL server to achieve this. We shall understand such a function which is the TRY_PARSE() function with the help of a suitable example.

The TRY_PARSE() Function is a type of function that is used to convert string type of data into numeric and date type of data. This type of function is very useful when we have data from users or some kind of external data where datatypes may vary. So this function handles the data very effectively and prevents errors.

For our example, we need the SQL Server 2012 installed along with the SQL Server Management Studio workbench.

Syntax:

TRY_PARSE(data AS dataType)

Explanation: Here data is the given column(student_dob) to be converted while the dataType specifies the required format into which the data must be converted to.

SQL Server is a Relational Database Management System(RDBMS), which is used to handle, manage and utilize the data of organizations and so on. It provides various effective functions to manage things efficiently and gives exceptional output. In this article, we will understand one of the important functions which is the TRY PARSE function in detail. After reading this article you will have in-depth knowledge about TRY PARSE Function.