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

"since today" doesn't start at 12 am


#1

I’m trying to get a simple count on total number of times an endpoint has been accessed today. I’m using the “today” since value but it’s not starting at 12am, rather 16:00

SELECT count(*) from Transaction where name='Controller/apps/zz/api/v1/users/create' and httpResponseCode=201 since today COMPARE WITH 1 day ago


#2

Hi, @chris.roerig: You may find this post helpful:


#3

Thanks, Phil. Using with timezone was exactly what I needed.