Android SQLite tip - default datetime to now

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:

insert into projects (project_type, name, description)
  values ('APPLICATION', 'Amazon - Purchasing', 'The description here');

then query the table like this:

select * from projects;

you'll see that the default datetime was set to 'now':

1|Amazon - Purchasing|The description here|2012-02-05 20:22:55

Reporting live from sunny Boulder, Colorado, I hope this Android SQLite "default date time" example has been helpful.