Sensor with offset date

From what I have seen/read, it would require direct database update. The challenge will be to have both short_term and stats aligned. I am not sure if SQL integration allows to write, I know Nodered does but that just makes it even more complex as integration/

I am looking for a similar thing related to the EDF (MyED) integration which only gives yesterday but have not had the time to look at it as low prio (using linky).
I will follow your French thread as well :slight_smile:

EDIT: SQL won’t ‘insert’ with my mariadb recorder… looking at some other threads they use shell command (with mysql client installed) or python scripts, example…

How do I call an Insert SQL command to MariaDB addon? - Installation / Home Assistant OS - Home Assistant Community (home-assistant.io)