The PARSE Function
The PARSE
function can be used to convert any string value to a numeric or to a date and time format only. The syntax is as follows:
PARSE ( string_value AS data_type [ USING culture ] )
The main difference from the standard CONVERT
or CAST
function is that you can provide a culture option to specify whether the string_value
is being passed in a culture-specific format (such as a date or money value). In addition, PARSE
handles numeric conversions that CONVERT
or CAST
will not, such as converting the string '100.00'
to the int
data type, as shown in the following example:
select convert(int,'100.0')goselect parse('100.00' as int)go/* output convert-----------Msg ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.