Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Relic Solution: Displaying Insights Results for Your Timezone

insights
timezone
utc

#1

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:

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:

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

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.


"since today" doesn't start at 12 am
#2

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.


#3

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