String_To_DateTime2

Retrieves a datetime2 value from a string.

Syntax:

SELECT SQLHTTP.net.String_To_DateTime2 ( @String )

Arguments:

Name	Type	Description
@String	varchar(MAX)	Any character string, variable, or expression.

Return Type:

datetime2

Remarks:

This powerful function is able to convert strings to dates in many uncommon formats. However, it is relatively slow so use sparingly.

Sample Usage:


SELECT SQLHTTP.net.String_To_DateTime2('2017-11-21T14:37:03.380 +05')

SELECT SQLHTTP.net.String_To_DateTime2('2017-11-21T14:37:03.380 +05')

---------------------------------

2017-11-21 01:37:03.3800000