Deprecated. Don't use for new development and try to migrate existing uses.
This function can be used to validate if a conversion to the datetime datatype is possible for a given string.
The special case of a null-string will give a return value of 0.
Use the built-in SQL server function
SELECT TRY_CONVERT(datetime2(2), x);
Be careful with differences in behavior for ''.
Returns 1 if conversion is possible and 0 otherwise.