public List<Tarefa> selecionarTodos() throws ParseException { List<Tarefa> lista = new ArrayList<Tarefa>(); // Abrir o banco de dados para leitura db = helper.getReadableDatabase(); // Obter os dados da tabela Cursor cursor = db.query("tarefa", null, null, null, null, null, "dataLembrete"); SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy"); String auxData; // Inserir dados do cursos na lista instanciada anteriormente if (cursor.moveToFirst()) { do { Tarefa Tarefa = new Tarefa(); Tarefa.setId(cursor.getInt(cursor.getColumnIndex("id"))); Tarefa.setDescricao(cursor.getString(cursor.getColumnIndex("descricao"))); auxData = String.valueOf(cursor.getInt(cursor.getColumnIndex("dataLimite"))); System.out.println(auxData + auxData.length()); if (!auxData.equals("") && !auxData.equals(null) && !auxData.isEmpty() && !auxData.equals("0")) { if (auxData.length() == 7) { auxData = "0" + auxData; } auxData = auxData.subSequence(0, 2).toString().concat("/") + auxData.subSequence(2, 4).toString().concat("/") + auxData.subSequence(4, 8).toString(); System.out.println(auxData + " teste"); Tarefa.setDataLimite(sdf.parse(auxData)); } System.out.println("passou"); auxData = ""; auxData = String.valueOf(cursor.getLong(cursor.getColumnIndex("dataLembrete"))); if (!auxData.equals("") && !auxData.equals(null) && !auxData.isEmpty() && !auxData.equals("0")) { if (auxData.length() == 7) { auxData = "0" + auxData; } auxData = auxData.subSequence(0, 2).toString().concat("/") + auxData.subSequence(2, 4).toString().concat("/") + auxData.subSequence(4, 8).toString(); Tarefa.setDataLembrete(sdf.parse(auxData)); } auxData = ""; auxData = String.valueOf(cursor.getLong(cursor.getColumnIndex("dataRealizacao"))); if (!auxData.equals("") && !auxData.equals(null) && !auxData.isEmpty() && !auxData.equals("0")) { if (auxData.length() == 7) { auxData = "0" + auxData; } auxData = auxData.subSequence(0, 2).toString().concat("/") + auxData.subSequence(2, 4).toString().concat("/") + auxData.subSequence(4, 8).toString(); Tarefa.setDataRealizacao(sdf.parse(auxData)); } auxData = ""; Tarefa.setStatus(cursor.getString(cursor.getColumnIndex("status"))); Tarefa.setUsername(cursor.getString(cursor.getColumnIndex("username"))); Tarefa.setIdCategoria(cursor.getInt(cursor.getColumnIndex("idCategoria"))); lista.add(Tarefa); } while (cursor.moveToNext()); } cursor.close(); db.close(); helper.close(); return lista; }