Relic Solution: Displaying Insights Results for Your Timezone

Unless otherwise specified, NRQL queries show results in UTC. Use WITH TIMEZONE and the time ranges will be relative to your timezone (or the timezone of the team you are supporting). WITH TIMEZONE works with today, this week, this month, this quarter, this year, days of the week, and any timestamp. For example:

InsightsTZ.png815x38 10.8 KB

Or, you might really only care about performance relative to your business hours. For example, starting at 8am on Monday and end on Friday at 5pm. Use the dates and times in conjunction with WITH TIMEZONE to see the data you want:

InsightsTZ3.png705x56 13.8 KB

Pro Tip: Typing WITH TIMEZONE will automatically display the full list of timezones:

TZlist.png413x518 28.2 KB

You can reduce the list of timezones by typing the first characters of your timezone:

A tip of the Nerd-Relic cap to Henry Shapiro, Insights Product Manager, for sharing this tip.

Very helpful when you have timezones which use daylight savings time. Means that you don’t have to add BST or GMT on the end of timestamp based queries. Saved me some troublesome queries once I realised that it existed.

Thanks for the feedback @stefan_garnham - I’m sure if you find it useful others will too!