Hello, I want to use the SQL sensor to read out the database form a bookingsystem I installed on my homeserver. The problem is that the data from the database is a time, which I want to use to trigger an automation in HA, but HA doesn´t show me this sensor as pickable option. How can I tell HA that the SQL sensor with the time can be used for automations?
What does the state of the sensor look like?
Where are you trying to “pick” it?
I will explain my setup. I have a bookingsystem running in a VM on my homeserver and there is a database where all bookings are stored. Because I found no other way to get the data to HA (which is running in an other VM) I use the SQL integration to readout the data over local network from the SQL server on the bookingsystem. The value in the database is a timestamp, but if I want to get this value with HA there is no value in the sensor. So I convert the timestamp from the SQL database to a string in my SELECT command of the integration and this is working, but thats also the point where I´m standing for now.
To trigger an automation with this you need a template trigger, where you compare the time from the sensor, which you will need to convert in datetime or timestamp, against the current time.
All necessary information can be found here:
Hello, thanks for the answer, now everything is working fine for me.