I have a table: CREATE TABLE Log ( TimeStamp char(14), -> Format YYYYMMDDHHNNSS Code char(5), -> 5 digit status code )
example: 20080314100030 A0001 20080314101000 A0002 20080314101700 A0000 20080314102000 A0002 20080314102100 A0000 I would like a query to output the the time between the status codes (sum) to know how long each status has been active. I am not so very familiar with SQL and SQLite, and I hope I am posting to the correct forum. Is this possible? Any hints and ideas are welcome! -- View this message in context: http://www.nabble.com/Value-between-changes-tp16048109p16048109.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users