Hi ,
I have table that represent a switch activity like this :
| date | state | | 2005-04-20 17:00:00 | 0 | | 2005-04-20 17:00:15 | 0 | | 2005-04-20 17:00:30 | 1 | | 2005-04-20 17:00:45 | 1 | | 2005-04-20 17:01:00 | 1 | | 2005-04-20 17:01:15 | 0 | | 2005-04-20 17:01:30 | 0 | | 2005-04-20 17:01:45 | 0 |
I want to get the date of each states change but i not a sql expert. Can someone advices me
Thanks
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
