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


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


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


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