Trouble to extract dateTime with Sqlite Android

Question

this is my code :

String sqlcomment="SELECT createdBy, text, documentPath, editedDate, actualityCommentID, actualityID FROM ActualityComment WHERE actualityID="+actual.getCode();

Cursor curcomment;
SQLiteDatabase  dbase = openOrCreateDatabase("leymaxdb.sqlite",SQLiteDatabase.CREATE_IF_NECESSARY,null);

 curcomment = dbase.rawQuery(sqlcomment, null);
 int maxid=0;
     if (curcomment.moveToFirst()) {
        do
        {
           System.out.println(curcomment.getString(3).toString());
        }while (curcomment.moveToNext());

    }

    dbase.close();

the error is in this line because i need to print editedDate from database and this is DateTime

System.out.println(curcomment.getString(3).toString());

And this is the android error :

java.lang.NullPointerException

Debug and check , the value of curcomment.getString(3). May be it returns null value.. — Lokesh, Feb 06 '14 at 09:35
http://stackoverflow.com/questions/12457926/storing-retrieving-datetime hope it will help you. — Sanket Shah, Feb 06 '14 at 09:52

score 0 · Answer 1 · answered Feb 06 '14 at 09:38

check what the value of actual.getCode() is and also check for cursor that cursor is null or not. then access it . may be database does not contain any record for that query.

after getting date as string pass that value to SimpleDateFormat to make the date object.

score 0 · Answer 2 · answered Feb 06 '14 at 09:43

First check, database created? having value or not?

do it by taking .db file from file explorer.

once db having values,

then read date value from cursor and display like below:

Date date = new Date(curcomment.getString(3));
DateFormat dateFormat = android.text.format.DateFormat.getDateFormat(getApplicationContext());
mydate.setText("Time: " + dateFormat.format(date));

Trouble to extract dateTime with Sqlite Android

2 Answers2