It seems that in the create statement of NOTE_TABLE you're missing the data type for COLUMN_DATE. So you probably should have something like
public static final String CREATE_TABLE_NOTE = " create table " + NOTE_TABLE + " ( "
+ COLUMN_ID + " integer primary key autoincrement, "
+ COLUMN_TITLE + " text not null, "
+ COLUMN_MESSAGE + " text not null, "
+ COLUMN_CATEGORY + " text not null, "
+ COLUMN_DATE + " integer);";
For more information about dates in SQLite, see
Datatypes In SQLite Version 3[
^]