从oracle c++检索日期

#include <iostream>
#include <oci.h>

int main() {
    OCIEnv* env;
    OCIError* err;
    OCISvcCtx* svc;
    OCIStmt* stmt;
    OCIDefine* def;
    OCIDate* date;

    // 初始化OCI环境
    OCIEnvCreate(&env, OCI_DEFAULT, nullptr, nullptr, nullptr, nullptr, 0, nullptr);

    // 分配错误句柄
    OCIHandleAlloc(env, (void**)&err, OCI_HTYPE_ERROR, 0, nullptr);

    // 建立数据库会话
    OCILogon2(env, err, &svc, "username", 9, "password", 9, "dbname", 6, OCI_DEFAULT);

    // 准备SQL语句
    const char* sql = "SELECT date_column FROM table_name";
    OCIStmtPrepare2(svc, &stmt, err, sql, strlen(sql), nullptr, 0, OCI_NTV_SYNTAX, OCI_DEFAULT);

    // 执行SQL语句
    OCIStmtExecute(svc, stmt, err, 1, 0, nullptr, nullptr, OCI_DEFAULT);

    // 定义结果集列
    OCIDefineByPos(stmt, &def, err, 1, &date, sizeof(OCIDate), SQLT_DAT, nullptr, nullptr, nullptr, OCI_DEFAULT);

    // 获取结果集数据
    while (OCIStmtFetch2(stmt, err, 1, OCI_FETCH_NEXT, 0, OCI_DEFAULT) != OCI_NO_DATA) {
        // 处理日期数据
        sb4 year, month, day, hour, minute, second;
        OCIDateGetDate(date, &year, &month, &day);
        OCIDateGetTime(date, &hour, &minute, &second);
        std::cout << "Date: " << year << "-" << month << "-" << day << " " << hour << ":" << minute << ":" << second << std::endl;
    }

    // 释放资源
    OCILogoff(svc, err);
    OCIHandleFree(stmt, OCI_HTYPE_STMT);
    OCIHandleFree(err, OCI_HTYPE_ERROR);
    OCIHandleFree(env, OCI_HTYPE_ENV);

    return 0;
}