Android SQLite FAQ: How do I default a SQLite datetime field to the current time, i.e., now?
Just use the SQLite "default current_timestamp" syntax, as shown in bold here:
create table projects (
_id integer primary key autoincrement,
name text not null,
description text,
date_created datetime default current_timestamp
);
If you create your table like that, then insert a sample record into the table like this: