"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.