Re: [sqlite] How should i found time difference between two events in sqlite3 table , like on off status

sanjeev wrote: > sqlite> select sdata ,timestamp from tbl_sensor where nid=4 and timestamp >> =date('now','-4 days') order by timestamp ASC ;0|2014-08-28 > 04:00:320|2014-08-28 04:56:420|2014-08-28 04:57:410|2014-08-28 > 04:58:410|2014-08-28 04:59:410|2014-08-28 05:22:410|2014-08-28 > [...] This

[sqlite] How should i found time difference between two events in sqlite3 table , like on off status

sqlite> select sdata ,timestamp from tbl_sensor where nid=4 and timestamp >=date('now','-4 days') order by timestamp ASC ;0|2014-08-28 04:00:320|2014-08-28 04:56:420|2014-08-28 04:57:410|2014-08-28 04:58:410|2014-08-28 04:59:410|2014-08-28 05:22:410|2014-08-28 05:23:410|2014-08-28