[FIXED] How to get Last 3 hours data from SQLite

Issue

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.
href="https://stackoverflow.com/questions/33254848/getting-data-according-to-last-hours-from-sqlite">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.

Solution

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')

Answered By - Shashank Kumar
Answer Checked By - Mary Flores (JavaFixing Volunteer)