I have a sensor driven by a sql query. This worked fine with the basic sqlite3.
I have moved to MariaDB and it is clear there are syntax differences.
sqllite: select substr(datetime(created,‘localtime’),1,16) from states
mariadb: ???
Help !
I have a sensor driven by a sql query. This worked fine with the basic sqlite3.
I have moved to MariaDB and it is clear there are syntax differences.
sqllite: select substr(datetime(created,‘localtime’),1,16) from states
mariadb: ???
Help !