4,011
社区成员
发帖
与我相关
我的任务
分享
sqlite3 *db = NULL;
int rc = sqlite3_open("data.db", &db);
if (rc == SQLITE_OK) {
char sqlstr[256] = { 0 };
const char *date = "2015-05-05 10:00:00";
snprintf(sqlstr, 256, "INSERT INTO table (date) VALUES (datetime('%s'));", date);
rc = sqlite3_exec(db, sqlstr, NULL, NULL, NULL);
if (rc == SQLITE_OK) {
printf("insert successful!\n");
} else {
printf("insert failed!\n");
}
sqlite3_close(db);
}
insert into Effluent VALUES(datetime('2015-04-12 26:00:00'));
datatime括号里面的数怎么用变量替代