>>>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#StyleArgumentsfortheCONVERTFunction>
>Thanks, 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?
I think I would create 2 methods:
UTCToDateTime(string) and UTCToDateTime(string, string)