Insert sqlite timestamp via ContentValues

Question

Hi all,

in Android is it possible to insert a sqlite timestamp into a database using ContentValues?

When I try to add it using something like

ContentValues args = new ContentValues();       
 args.put(MY_DATE,my_date);

I get an error telling me that my_date needs to be a string

Answer 1

Neither Date nor Calendar are valid things to put in a ContentValues. The most efficient format, I think, is to convert the Date to milliseconds (getTime()) and store that in an INTEGER column.