How to get Last 3 hours data from SQLite

Question

I am inserting data in table with current system time like System.currentTimeMillis(). So, while getting data I need to take last 3 hours data only.

Following link not help me. because this link using specific date format which I don't have.
Getting data according to last hours from sqlite

Here Is my Query but seems it's not working.

SELECT * FROM Table1 where timestamp >= datetime('now','-3 hours')    

Where timestamp is nothing but current system time while inserting.

Please give me any reference or hint.

Answer 1

You can get TimeStamp of Time 3 Hours back using following

Calendar cal = Calendar.getInstance();
cal.add(Calendar.HOUR, -3);
Date threeHourBack = cal.getTime();

Then you can pass threeHourBack.getTime() to the query.

Or You can do this in SQLite

SELECT * FROM Table1 where datetime(timestamp) >=datetime('now', '-3 Hour')