0

I have date in sqlite but in timestamp format, I want to set that date into a text view but in actual date format any idea?

This saved my date in sqlite in timestamp format:

void insertNewTask(String task, String date)
{
 SQLiteDatabase db= this.getWritableDatabase();
 ContentValues values = new ContentValues();
 values.put("TaskName",task);
 values.put("dateStr", getDate(date));
 db.insertWithOnConflict(DB_TABLE,null,values,SQLiteDatabase.CONFLICT_REPLACE);
 db.close();
}

and now I want to get date in actual format and set it into text-view:

ArrayList<String> getTaskList()
{
 ArrayList<String> taskList = new ArrayList<>();
 SQLiteDatabase db = this.getReadableDatabase();
 Cursor cursor = db.query(DB_TABLE,new String[]{"TaskName","dateStr"},null,null,null,null,null);
 while(cursor.moveToNext()){
 int index = cursor.getColumnIndex("TaskName");
 taskList.add(cursor.getString(index));
}
 cursor.close();
 db.close();
 return taskList;
}

I have this getDate() Method:

private long getDate(String day) 
{
 SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy", Locale.getDefault());
 Date date = new Date();
 try 
{
  date = dateFormat.parse(day);
}
 catch (ParseException e) {}
 return date.getTime(); //I have used this method in insertNewTask()
}
Syed Zaidi
  • 21
  • 7

0 Answers0