How to add date in sqlite database

Question

I have sqlite database

    private static final String DB_PROCESS_CREATE = "create table "         + DB_TABLE_PROCESS + "(" + PROCESS_ID         + " integer primary key autoincrement, "         + PROCESS_DATE + " date);"; 

I create it db.execSQL(DB_PROCESS_CREATE);

How to add date value in this database? I tried :

String date = new SimpleDateFormat("yyyy.MM.dd").format(Calendar .getInstance().getTime()); ContentValues cv = new ContentValues(); cv.put(db.PROCESS_DATE,Date.valueOf(date)); db.mDB.insert(db.DB_TABLE_PROCESS, null, cv)); 

But then I get error :

"The method put(String, String) in the type ContentValues is not applicable for the arguments (String, Date)". 

Answer 1

Now when you want to insert date to database, you can use this code.

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); String date = sdf.format(new Date()); 

In database insert the string 'date'

The date format in sqlite should be of following format:

YYYY-MM-DD YYYY-MM-DD HH:MM YYYY-MM-DD HH:MM:SS YYYY-MM-DD HH:MM:SS.SSS YYYY-MM-DDTHH:MM YYYY-MM-DDTHH:MM:SS YYYY-MM-DDTHH:MM:SS.SSS HH:MM HH:MM:SS HH:MM:SS.SSS now DDDDDDDDDD  

For more details, have a look: http://www.sqlite.org/lang_datefunc.html