>>What would be the terminology to use to recognize this specific date time format:
>>
>>2015-06-25T08:06:31-04:00
>>
>>...and this one:
>>
>>2015-06-25T08:11:41
>
>Looks like ISO 8601
>
>See String Literal Date and Time Formats here...
>
https://technet.microsoft.com/en-us/library/ms180878(v=sql.105).aspx#StyleArgumentsfortheCONVERTFunctionThanks, I am doing a few verifications on actual methods I have to see about the proper naming to use.
On the first date, that would UTCToDateTime() assuming I am passing that string to obtain a date.
The second one is not obvious. It is also UTC but without the time zone indicator. Is it better that I detect if I have a time zone in the same method or building a second method for such format?