TRY_PARSE() function
TRY_PARSE() function is introduced in SQL Server 2012. it convert any string value to Date/Time format or Numeric . If the input string value cannot be converted to Numeric or Date/Time format, it will give NULL result.
Syntax:- TRY_PARSE (input_value AS data_type [ USING culture ])
Example:-
First query try to parse a string to date type, it fails and returns NULL value.
Second query successfully parse to date type and return result -- 2016-08-14.
Third query also successfully parse with in UK format.
TRY_PARSE() function is introduced in SQL Server 2012. it convert any string value to Date/Time format or Numeric . If the input string value cannot be converted to Numeric or Date/Time format, it will give NULL result.
Syntax:- TRY_PARSE (input_value AS data_type [ USING culture ])
Example:-
DECLARE @InputString1 AS varchar(10); DECLARE @InputString2 AS VARCHAR(10); SET @InputString1 = 'www.code-view.com'; SET @InputString2 = '08/14/2016'; SELECT TRY_PARSE(@InputString1 AS DATE); --NULL SELECT TRY_PARSE(@InputString2 AS DATE); -- 2016-08-14 SELECT TRY_PARSE(@InputString2 AS DATE USING 'en-UK'); -- 2016-08-14
First query try to parse a string to date type, it fails and returns NULL value.
Second query successfully parse to date type and return result -- 2016-08-14.
Third query also successfully parse with in UK format.
No comments:
Post a comment