Sensortype | Sensorvalue | Time |
SensorA | 12 | 12:00:00 |
SensorB | 12 | 12:00:00 |
I created the table with:
Create table xmpltbl(id integer primary key autoincrement, currentdate time);
I inserted the values with the following sql command:
Insert into xmpltbl (currentdate) values (strftime('%Y-%m-%d %H:%M%S', 'date(now)'));