SQL Service Broker 2012 queue has message_enqueue_time in GMT

Question

It seems that message_enqueue_time in SQL Service Broker is in GMT rather than local time.

Is there any configuration that needs to be done to get this to show up in local time?

Thank you,

Answer 1

All times related to SQL Service Broker are expressed as UTC. This is intentional and non configurable. Displaying local time in the application is trivial, use whatever your client framework offers for converting UTC to your local.