Unix时间戳与ISO时间字符串转换不一致问题及代码修正请求

核心问题 #

你的from_isoTimeString函数错误地使用了mktime处理UTC时间：

• mktime的设计目标是将本地时间的std::tm对象转换为time_t，但你的ISO字符串是带Z的UTC时间，直接调用mktime会自动加入本地时区与UTC的偏移，导致结果偏差。
• 手动减去_timezone的方式不可靠：_timezone仅反映标准时区偏移，未考虑夏令时（DST），且不同平台（Windows/POSIX）对_timezone的定义存在差异，无法保证正确性。

修正方案 #

方案1：使用平台原生UTC转换函数 #

POSIX系统提供timegm，Windows提供_mkgmtime，这两个函数的作用是将UTC时间的std::tm对象转换为time_t，完美匹配你的需求：

#include <iomanip>
#include <iostream>
#include <sstream>
#include <string>
#include <stdexcept>

uint64_t from_isoTimeString(std::string iso_time_string)
{
    std::tm tmb{}; // 初始化结构体，避免未定义行为
    std::stringstream ss(iso_time_string);
    ss >> std::get_time(&tmb, "%Y-%m-%dT%TZ");
    if (ss.fail())
    {
        throw std::invalid_argument("unable to convert Timestamp '" + iso_time_string + "' from ISO 8601 format");
    }

    // 明确标记为UTC时间，无夏令时
    tmb.tm_isdst = 0;

    std::time_t utc_tt;
#ifdef _WIN32
    utc_tt = _mkgmtime(&tmb);
#else
    utc_tt = timegm(&tmb);
#endif

    if (utc_tt == -1)
    {
        throw std::invalid_argument("Failed to convert UTC time to timestamp");
    }

    return static_cast<uint64_t>(utc_tt);
}

// 原formatTimestamp函数无需修改
std::string formatTimestamp(uint64_t epoch_seconds, std::string timestamp_format)
{
    std::time_t tt = epoch_seconds;

    std::tm tmb;
    gmtime_s(&tmb, &tt);

    std::stringstream ss;
    ss << std::put_time(&tmb, timestamp_format.c_str());
    if (ss.fail())
    {
        throw std::invalid_argument("unable to convert Timestamp to " + timestamp_format + " format");
    }
    return ss.str();
}

int main() 
{
    uint64_t time1_uint = 1656331210;
    std::string time1_str = "2022-06-27T12:00:10Z";

    std::cout << "            time1_str: " << time1_str << std::endl;
    std::cout << " time1_uint as string: " << formatTimestamp(time1_uint, "%Y-%m-%dT%TZ" ) << std::endl;
    std::cout << "           time1_uint: " << time1_uint << std::endl;
    std::cout << "time1_str from string: " << from_isoTimeString(time1_str) << std::endl;
}

方案2：使用Howard Hinnant的date库（推荐） #

如果你已经在使用date.h库，代码会更简洁可靠，完全避免手动处理tm对象和时区问题：

#include <iomanip>
#include <iostream>
#include <sstream>
#include <string>
#include <stdexcept>
#include "date/date.h"
#include <chrono>

uint64_t from_isoTimeString(std::string iso_time_string)
{
    namespace chr = std::chrono;
    chr::sys_seconds tp;
    std::istringstream ss(iso_time_string);
    ss >> date::parse("%Y-%m-%dT%TZ", tp);
    if (ss.fail())
    {
        throw std::invalid_argument("unable to convert Timestamp '" + iso_time_string + "' from ISO 8601 format");
    }
    return static_cast<uint64_t>(tp.time_since_epoch().count());
}

// 原formatTimestamp函数可改用date库简化：
std::string formatTimestamp(uint64_t epoch_seconds, std::string timestamp_format)
{
    namespace chr = std::chrono;
    auto tp = chr::sys_seconds{chr::seconds{epoch_seconds}};
    return date::format(timestamp_format, tp);
}

int main() 
{
    uint64_t time1_uint = 1656331210;
    std::string time1_str = "2022-06-27T12:00:10Z";

    std::cout << "            time1_str: " << time1_str << std::endl;
    std::cout << " time1_uint as string: " << formatTimestamp(time1_uint, "%Y-%m-%dT%TZ" ) << std::endl;
    std::cout << "           time1_uint: " << time1_uint << std::endl;
    std::cout << "time1_str from string: " << from_isoTimeString(time1_str) << std::endl;
}

验证结果 #

修正后运行main函数，四个输出值将完全一致：

time1_str: 2022-06-27T12:00:10Z
 time1_uint as string: 2022-06-27T12:00:10Z
           time1_uint: 1656331210
time1_str from string: 1656331210

内容的提问来源于stack exchange，提问作者PeterT