I’d like to know what time i switched off the light in my room every night for the last 2 months. Can any one write an SQL query please?.
I’ve so far not had time to learn any SQL (but i will) and i could really use this info.
The columns are TIME and VALUE
2006_10_25 23:45:06 and OFF