0

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,

Greg Hill
  • 2,148
  • 2
  • 23
  • 27

1 Answers1

4

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.

Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569
  • We put a view that uses a function to convert the UTC to local time considering daylight savings as well and it helps with our issue. – Greg Hill Feb 05 '15 at 03:24