QMYSQL Insert a UTC time to datetime field

show variables like'%time_zone';
SELECT now();

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QDateTime>
#include <QDebug>
#include <QSqlError>
const QString TABLE_NAME = "time_test"; // Table name
bool createDatabase() {
    // Open MySQL database connection
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("test");
    db.setUserName("root");
    db.setPassword("123456");
    if (!db.open())
{         qDebug() << "Unable to open database:" << db.lastError().text();         return false;     }
    QSqlQuery query;
    // Create table with only the server_time field
    QString createTable = QString("CREATE TABLE IF NOT EXISTS %1 "
                                  "(id INT AUTO_INCREMENT PRIMARY KEY, "
                                  "server_time DATETIME)").arg(TABLE_NAME);
    if (!query.exec(createTable))
{         qDebug() << "Failed to create table:" << query.lastError().text();         return false;     }
    return true;
}
bool insertData() {
    QSqlQuery query;
    // SQL insert statement using placeholders
    QString sql = "INSERT INTO " + TABLE_NAME + " (server_time) VALUES ";
    query.prepare(sql);
    // Get the current date and time
    QDateTime currentTime = QDateTime::currentDateTime();
    qDebug() << currentTime;
    // Bind the current time to the server_time field
    query.addBindValue(currentTime);
    // Execute the insert
    if (!query.exec())
{         qDebug() << "Failed to insert data:" << query.lastError().text();         return false;     }
    qDebug() << "Data successfully inserted into the database";
    return true;
}
void checkInsertedData() {
    QSqlQuery query;
    // SQL query to select the inserted data
    QString selectSql = "SELECT server_time FROM " + TABLE_NAME;
    if (!query.exec(selectSql))
{         qDebug() << "Failed to query data:" << query.lastError().text();         return;     }
    while (query.next())
{         // Get the server_time field from the result         QDateTime serverTime = query.value(0).toDateTime();         qDebug() << "Retrieved record: server_time =" << serverTime;     }
}
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    // Create the database and table
    if (!createDatabase())
{         return -1;     }

    // Insert the data
    if (!insertData()) {         return -1;     }
    // Query and check the inserted data
    checkInsertedData();
    return a.exec();
}