我想在SQLite数据库中保存当前时间。我使用以下代码语法-
private static final String CREATE_GROUP_MESSAGES_TABLE = "create table if not exists "
+ TABLE_GROUP_MESSAGE
+ "( "
+ GROUP_NAME
+ " VARCHAR NOT NULL, "
+ ENTRY_FROM
+ " VARCHAR NOT NULL, "
+ COLUMN_GROUPTEXT
+ " TEXT NOT NULL, "
+ COLUMN_ISSENDMESSAGE
+ " VARCHAR NOT NULL, "
+ COLUMN_GROUPIMAGEPATH
+ " TEXT NOT NULL, "
+ GROUP_COLUMN_TYPE
+ " INTEGER NOT NULL, "
+ GROUP_COLUMN_KEY
+ " INTEGER primary key autoincrement, "
+ GROUP_COLUMN_TIMESTAMP
+ " DATETIME DEFAULT CURRENT_TIMESTAMP);";
但是上面给出的是按照GMT标准的时间。如何按照GMT+5或其他方式获取/存储时间。
谢谢
Just do:
GROUP_COLUMN_TIMESTAMP DATETIME DEFAULT (datetime('now','localtime'))
它将默认为用户的本地时间而不是GMT