General information
Category:
Coding, syntax and commands
Environment versions
Network:
Windows 2003 Server
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only