在android数据库中插入时间戳列

// 创建数据库表
public class MyDatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "my_database";
    private static final int DATABASE_VERSION = 1;

    public MyDatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建表
        String createTableQuery = "CREATE TABLE my_table (id INTEGER PRIMARY KEY, timestamp INTEGER)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库
        // ...
    }
}

// 插入数据
public void insertData() {
    SQLiteDatabase db = myDatabaseHelper.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put("timestamp", System.currentTimeMillis());
    long newRowId = db.insert("my_table", null, values);
}