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 is unreadable. > plz help me out ... At the right side of your keyboard is the Enter key. It allows you to insert line breaks. HTH&HAND Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users