Which built-in function you can use for converting string data type to date/time and number type ?

Translated to the requested data type, or null if the cast fails in SQL Server 2012.

Relies on the presence of the .NET Framework CLR.

SELECT TRY_PARSE('rajesh' AS datetime2 USING 'hi-IN')

return : Null