SQL Server Denali introduced new conversion functions: PARSE() and TRY_PARSE().
PARSE() function
PARSE() function converts expression (string value) to date/time and number data types if conversion is possible. If conversion isn’t possible it raises an error.
-- Parse to datetime specifying cul......