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