Hi,
I am inserting date in database as,

long curr_date = System.currentTimeMillis();
When I look at my database the date appears as 2014-03-18. If date is less than 2 days.I want to pull my data , name and store it in a string.
How can I achieve that?. The below method pulls all the data from the database but doesn't pulls it querying just the date. Please help. Thanks

public static final String KEY_DATE = "current_date";
 
String[] columns = new String[]{KEY_ROWID, KEY_NAME, KEY_DATE};
String result =" ";
 
Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null);
 
int iRow = c.getColumnIndex(KEY_ROWID);
           		int iName = c.getColumnIndex(KEY_NAME);
 
           		for(c.moveToFirst();!c.isAfterLast(); c.moveToNext()){
 
 
           			result = result + c.getString(iName) + ",";    
 
           		}
           		return result;