#include <iostream>
#include <sqlite3.h>
int main() {
sqlite3 *db;
char *errMsg = 0;
const char *sql = "PRAGMA foreign_keys=off;"
"BEGIN TRANSACTION;"
"CREATE TEMPORARY TABLE backup(dbfield TEXT);"
"INSERT INTO backup SELECT dbfield FROM your_table;"
"DROP TABLE your_table;"
"CREATE TABLE your_table(dbfield DATETIME);"
"INSERT INTO your_table SELECT dbfield FROM backup;"
"DROP TABLE backup;"
"COMMIT;";
int rc = sqlite3_open("your_database.db", &db);
if (rc != SQLITE_OK) {
std::cerr << "Cannot open database: " << sqlite3_errmsg(db) << std::endl;
return rc;
}
rc = sqlite3_exec(db, sql, 0, 0, &errMsg);
if (rc != SQLITE_OK) {
std::cerr << "SQL error: " << errMsg << std::endl;
sqlite3_free(errMsg);
}
sqlite3_close(db);
return rc;
}