Android Question log file...

one possible solution .. create new table daily ,tablename = date.
then delete previous days table.

asuming your timestamp is an unix-timestamp (seconds since 1.1.1070 0:00)

Calculate the timestamps of yesterday.
timestamp1: yesterday 0:00 AM (midnight)
timestamp2 = timestamp1 + 86400

then in Database
delete from mytable where timestamp>= timestamp1 and timestamp <= timestamp2

I´m not really familar with sqlite on Android so i can´t give you an concrete example. But my post should give you an suggestion on how to do it...

this must be the easiest way (if it works )

I´m not familar with sqlite like i said. and he was talking about timestamp. so i though on unixtime-stamp...
If "timestamp" is like kind of "201409201706" then i would say that there must me "date-routines" inside sqlite.

Ok, I'm using the Android system date & time and inserting that into a record. I should be able to use that, if not I'l swap it out.