I have a widget that has the standard ranges - Today, Yesterday, This Week, etc...
I have 7 rows of data in my table with today's date - 2202-05-10. When I run select now() in my db, I get the current date and time - 2022-05010 22:42:22.
When the widget loads, and I select the Today range, the metric doesn't show the value but if I select Yesterday, the metric does show the correct value.
How do I make sure that the Today range is set to the correct timezone or locale?