convert datatype of field db browser from text to timedate db browser

#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;
}