SQL Server T-SQL has functions built in to handle UTC conversion.

>On a specific Web Service, I need to send a datetime value in respect to the UTC offset time zones. This goes like this:
>
>2011-08-23T17:05:04.859-17:05
>
>But, the problem is the last part. The 17 should be between 0 and 12. If this is Montreal time, what is the proper formula to convert 17 to its proper hour UTC offset equivalent?