如何在MySQL连接器/C++ 8.0中使用DATETIME？

#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/driver.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>

sql::mysql::MySQL_Driver *driver;
sql::Connection *con;

driver = sql::mysql::get_mysql_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "username", "password");
con->setSchema("database_name");

sql::Statement *stmt;
stmt = con->createStatement();
stmt->execute("INSERT INTO table_name (datetime_column) VALUES (NOW())");

sql::ResultSet *res;
res = stmt->executeQuery("SELECT datetime_column FROM table_name");

while (res->next()) {
  std::cout << "Datetime: " << res->getString("datetime_column") << std::endl;
}

delete res;
delete stmt;
delete con;