@TODAY() Function

In Grafana I like to have a mix of time periods in my dashboards, so some that are driven by the selection and some that remain static based on what I choose.

I would like to replicate the “Today” you can choose from the top down but do it in the query so it won’t be changed by what I choose.

So something like this;

SELECT count("blink") FROM "house" WHERE time = today()

Hopefully this makes sense, any suggestions?


Hello @doowle,
Does this alternative work for you?

time > now() - 24h

Or do you need data only from today’s date up to the hour that you’re querying?


I just want today, not the last 24 hours sorry.

If this was in MS-SQL I could get today’s date in the where clause, just no idea where to start here…