How to insert a SQLite record with a datetime set to ‘now’ in Android application?
You cannot use the datetime function using the Java wrapper “ContentValues”. Either you can use : SQLiteDatabase.execSQL so you can enter a raw SQL query. mDb.execSQL(“INSERT INTO “+DATABASE_TABLE+” VALUES (null, datetime()) “); Or the java date time capabilities : // set the format to sql date time SimpleDateFormat dateFormat = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”); Date date … Read more