SQL to get historic attribute data from MariaDB

Configuration
1

Hi,

I’m using MariaDB and install phpDBAdmin to get hostoric data from a sensor (fritz call montor). So I want to show the last calls with details of the day but if I add curdate to WHERE I did not get any data:

SELECT state FROM states WHERE entity_id = ’ sensor.fritz_box_7590_call_monitor_privat’ AND last_updated >= CURDATE() ORDER BY last_updated DESC

Whats the problem and how can I create a Wherer with dat_time?

Thanks, Steffen

2

Looking at the data in my database, last_updated is UTC, so you would have to use the following:

last_updated >= utc_date()
3

Great thank you, UTC is the key I did not find.