个人网站备注模板扬中吧百度贴吧

个人网站备注模板,扬中吧百度贴吧,厦门响应式网站,建设项目验收 网站全面测试QtSql操作PostgreSQL数据库时戳字段的行为 文章目录全面测试QtSql操作PostgreSQL数据库时戳字段的行为1. 需求分析2. 测试原理3. 数据库准备3.1 运行bash脚本创建数据仓库3.2 运行sql脚本创建数据库4. 开发测试程序4.1 项目文件(1) CMakeLists格式(2) qmake格式4.2 C代…全面测试QtSql操作PostgreSQL数据库时戳字段的行为文章目录全面测试QtSql操作PostgreSQL数据库时戳字段的行为1. 需求分析2. 测试原理3. 数据库准备3.1 运行bash脚本创建数据仓库3.2 运行sql脚本创建数据库4. 开发测试程序4.1 项目文件(1) CMakeLists格式(2) qmake格式4.2 C代码5. 产生数据内容6. 结果详细分析6.1 核心影响因素及作用机制6.2 常见问题与风险点6.3 query日期比较的行为规律与结果差异解析6.3.1 能查询到结果的典型场景及原因6.3.2 查不到结果的典型场景及原因6.3.3 核心结论7. 编程最佳规范建议7.1 字段类型选择7.2 插入操作规范7.3 数据库会话配置7.4 读取与转换操作7.5 测试与验证7.6 查询操作规范附件 query_data 历次输出结果(1) 计算机为北京时间(2) 计算机为UTC时间(3) 计算机为芝加哥时间1. 需求分析Qt 作为客户端采用Sql模块操作PostgreSQL数据库的时戳字段时会遇到不同的操作途径导致的行为差异。具体来说因为操作系统时区、数据库连接会话时区、字段类型、QDateTime对象时区等因素的不同会组合出非常多的可能行为。这些差异因为出现在数据库建立、写入、搬运、比较的各个环节导致的级联不一致问题会组合出上百钟情况。为了深入理解技术细节导致的结果异同为现场排查数据不一致性提供全面的测试数据准备利用本次实验进行一个整理、总结。2. 测试原理本测试通过双层模拟枚举各种可能的搭配。上层是基于OS的时区配置每个配置运行1次测试程序共模拟三个不同的操作系统时区北京时刻、芝加哥时刻、伦敦时刻。下层是分别测试QDateTime时区2种包括本地时刻即上层时区、UTC时刻。SQL会话时区3种包括北京时刻、芝加哥时刻、伦敦时刻。SQL绑定方式3种包括QDateTime对象绑定、无时区字符串绑定、有时区字符串绑定。双层测试共产生54条记录。3. 数据库准备使用 windows 下的 msys2 ucrt64环境自带的 postgresql 18.1版本进行测试。3.1 运行bash脚本创建数据仓库initdb -D /d/testdb --localeC -U postgres psql -dpostgres -Upostgres3.2 运行sql脚本创建数据库ALTERUSERpostgresWITHPASSWORDpostgres;createdatabasetest;CREATEROLE testWITHLOGIN SUPERUSER CREATEDB CREATEROLE INHERIT NOREPLICATION BYPASSRLS CONNECTIONLIMIT-1PASSWORDtest;CREATEDATABASEtestWITHOWNERtest TEMPLATEtemplate1ALTERTABLEIFEXISTSpublic.test OWNERtotest;\q4. 开发测试程序测试程序基于Qt6.10.14.1 项目文件(1) CMakeLists格式# 指定 CMake 最低版本要求Qt 5 最低 3.5Qt 6 最低 3.16 cmake_minimum_required(VERSION 3.5) # 项目名称和版本可根据实际情况修改 project(test_pg_timestamp VERSION 1.0.0 LANGUAGES CXX) # 设置 C 标准强制 C17与 CONFIG c17 对应 set(CMAKE_CXX_STANDARD 17) set(CMAKE_CXX_STANDARD_REQUIRED ON) set(CMAKE_CXX_EXTENSIONS OFF) # 禁用编译器扩展确保标准一致性 # 查找 Qt 组件core 和 sql 模块与 QT core sql 对应 # 支持 Qt 5 和 Qt 6 自动适配 find_package(Qt6 REQUIRED COMPONENTS Core Sql) if (NOT Qt6_FOUND) find_package(Qt5 5.15 REQUIRED COMPONENTS Core Sql) # Qt5 最低 5.15 以良好支持 C17 endif() # 设置命令行模式与 CONFIG cmdline 对应不链接 GUI 模块 set(CMAKE_AUTOMOC ON) # 自动处理 Qt 的 moc 元对象编译Core 模块必需 set(CMAKE_INCLUDE_CURRENT_DIR ON) # 定义可执行文件目标 add_executable(${PROJECT_NAME} main.cpp # 源文件与 SOURCES main.cpp 对应 ) # 链接 Qt 库根据找到的 Qt 版本自动链接 target_link_libraries(${PROJECT_NAME} PRIVATE Qt${QT_VERSION_MAJOR}::Core Qt${QT_VERSION_MAJOR}::Sql )(2) qmake格式QT core sql CONFIG c17 cmdline SOURCES \ main.cpp4.2 C代码#includeQCoreApplication#includeQSqlDatabase#includeQSqlQuery#includeQDateTime#includeQString#includeQSqlError#includeQTimeZone#includeQTextStream#includeQSqlField#includeQSqlRecordstaticQTextStreamsterr(stderr);staticQTextStreamstout(stdout);voidcreate_table(QSqlQueryquery);voidwrite_data(QString name,QDateTimedtmobj,QSqlQueryquery,boolstr_insert,boolstr_usingtztrue);voidquery_data(QDateTimedtmobj,QSqlQueryquery,QString field_name,boolstr_insert,boolstr_usingtztrue);voidselect_table(QSqlQueryquery);intmain(intargc,char*argv[]){QCoreApplicationa(argc,argv);constQString tz_osQTimeZone::systemTimeZone().id();try{QSqlDatabase dbQSqlDatabase::addDatabase(QPSQL,test);if(!db.isValid())throwdb.lastError().text();db.setHostName(localhost);db.setPort(5432);db.setDatabaseName(test);db.setUserName(test);db.setPassword(test);if(!db.open())throwdb.lastError().text();QSqlQueryquery(db);//0. create tablecreate_table(query);//1.1 输入的是本地OS的元旦时刻QDateTime dtm_objQDateTime(QDate(2025,01,01),QTime(0,00,00));//1.1.1 数据库连接使用UTCQt默认query.exec(set timezone UTC;);write_data(L0Dtz_os,dtm_obj,query,false);//QDateTime对象插入write_data(L0Stz_os,dtm_obj,query,true,false);//不带时区字符串插入write_data(L0Ztz_os,dtm_obj,query,true,true);//携带时区字符串插入//1.1.2 数据库连接使用 Asia/Shanghai 8query.exec(set timezone Asia/Shanghai;);write_data(L8Dtz_os,dtm_obj,query,false);//QDateTime对象插入write_data(L8Stz_os,dtm_obj,query,true,false);//不带时区字符串插入write_data(L8Ztz_os,dtm_obj,query,true,true);//携带时区字符串插入//1.1.3 数据库连接使用 America/Chicago -6query.exec(set timezone America/Chicago;);write_data(L6Dtz_os,dtm_obj,query,false);//QDateTime对象插入write_data(L6Stz_os,dtm_obj,query,true,false);//不带时区字符串插入write_data(L6Ztz_os,dtm_obj,query,true,true);//携带时区字符串插入query_data(dtm_obj,query,data_tz,false);query_data(dtm_obj,query,data_tz,true,false);query_data(dtm_obj,query,data_tz,true,true);query_data(dtm_obj,query,data_ntz,false);query_data(dtm_obj,query,data_ntz,true,false);query_data(dtm_obj,query,data_ntz,true,true);query_data(dtm_obj,query,ntz2tz,false);query_data(dtm_obj,query,ntz2tz,true,false);query_data(dtm_obj,query,ntz2tz,true,true);query_data(dtm_obj,query,tz2ntz,false);query_data(dtm_obj,query,tz2ntz,true,false);query_data(dtm_obj,query,tz2ntz,true,true);//1.2 输入的是UTC元旦时间dtm_objQDateTime(QDate(2025,01,01),QTime(0,00,00),QTimeZone::utc());//1.2.1 数据库连接使用UTCQt默认query.exec(set timezone UTC;);write_data(U0Dtz_os,dtm_obj,query,false);//QDateTime对象插入write_data(U0Stz_os,dtm_obj,query,true,false);//不带时区字符串插入write_data(U0Ztz_os,dtm_obj,query,true,true);//携带时区字符串插入//1.2.2 数据库连接使用 Asia/Shanghai 8query.exec(set timezone Asia/Shanghai;);write_data(U8Dtz_os,dtm_obj,query,false);//QDateTime对象插入write_data(U8Stz_os,dtm_obj,query,true,false);//不带时区字符串插入write_data(U8Ztz_os,dtm_obj,query,true,true);//携带时区字符串插入//1.2.3 数据库连接使用 America/Chicago -6query.exec(set timezone America/Chicago;);write_data(U6Dtz_os,dtm_obj,query,false);//QDateTime对象插入write_data(U6Stz_os,dtm_obj,query,true,false);//不带时区字符串插入write_data(U6Ztz_os,dtm_obj,query,true,true);//携带时区字符串插入query_data(dtm_obj,query,data_tz,false);query_data(dtm_obj,query,data_tz,true,false);query_data(dtm_obj,query,data_tz,true,true);query_data(dtm_obj,query,data_ntz,false);query_data(dtm_obj,query,data_ntz,true,false);query_data(dtm_obj,query,data_ntz,true,true);query_data(dtm_obj,query,ntz2tz,false);query_data(dtm_obj,query,ntz2tz,true,false);query_data(dtm_obj,query,ntz2tz,true,true);query_data(dtm_obj,query,tz2ntz,false);query_data(dtm_obj,query,tz2ntz,true,false);query_data(dtm_obj,query,tz2ntz,true,true);//2. select table select_table(query);}catch(QString err){sterrError! err\n;sterr.flush();}sterr.flush();return0;}voidcreate_table(QSqlQueryquery){constQString sqlCREATE TABLE IF NOT EXISTS public.test_tz ( test_name character varying(255), tz_os character varying(255), tz_sql character varying(255), tz_src character varying(255), src_str character varying(255), src_utc bigint, opr_type character varying(255), data_tz timestamp with time zone, data_ntz timestamp without time zone, ntz2ts character varying(255), ntz2tz timestamp with time zone, tz2nts character varying(255), tz2ntz timestamp without time zone, PRIMARY KEY (test_name) );;if(!query.exec(sql))throwquery.lastError().text();}voidwrite_data(QString name,QDateTimedtmobj,QSqlQueryquery,boolstr_insert,boolstr_usingtz){constQString sqlINSERT INTO public.test_tz (test_name, tz_os, tz_sql, tz_src, src_str, src_utc,opr_type, data_tz, data_ntz) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT (test_name) Do NOTHING;;// 获取当前系统时区constQString tz_osQTimeZone::systemTimeZone().id();// 获取会话时区if(!query.exec(show timezone;))throwquery.lastError().text();if(!query.next())throwQString(\nError. Can not get session timezone.\n);constQString tz_sqlquery.value(0).toString();//获取来源时区、来源的字符串constQString tz_srcdtmobj.timeZone().id();constQString src_strstr_usingtz?dtmobj.toString(yyyy-MM-ddTHH:mm:ss.zzzt):dtmobj.toString(yyyy-MM-dd HH:mm:ss.zzz);constqint64 src_utcdtmobj.toSecsSinceEpoch();//Insertif(!query.prepare(sql))throwquery.lastError().text();query.addBindValue(name);query.addBindValue(tz_os);query.addBindValue(tz_sql);query.addBindValue(tz_src);query.addBindValue(src_str);query.addBindValue(src_utc);if(str_insert){query.addBindValue(str_usingtz?QStringzone:QString);query.addBindValue(src_str);query.addBindValue(src_str);}else{query.addBindValue(QDateTime);query.addBindValue(dtmobj);query.addBindValue(dtmobj);}if(!query.exec())throwquery.lastError().text();if(true){//read and mov data tz-ntzif(!query.prepare(select data_tz from public.test_tz where test_name ?;))throwquery.lastError().text();query.addBindValue(name);if(!query.exec())throwquery.lastError().text();if(!query.next())throwQString(\nError. Can not get data_tz.\n);constQDateTime dtmValquery.value(0).toDateTime();constQString textDatestr_usingtz?query.value(0).toString():dtmVal.toString(yyyy-MM-dd HH:mm:ss.zzz);if(!query.prepare(update public.test_tz set tz2nts ?, tz2ntz ? where test_name ?;))throwquery.lastError().text();query.addBindValue(textDate);if(str_insert)query.addBindValue(textDate);elsequery.addBindValue(dtmVal);query.addBindValue(name);if(!query.exec())throwquery.lastError().text();}if(true){//read and mov data ntz-tzif(!query.prepare(select data_ntz from public.test_tz where test_name ?;))throwquery.lastError().text();query.addBindValue(name);if(!query.exec())throwquery.lastError().text();if(!query.next())throwQString(\nError. Can not get data_ntz.\n);constQDateTime dtmValquery.value(0).toDateTime();constQString textDatestr_usingtz?query.value(0).toString():dtmVal.toString(yyyy-MM-dd HH:mm:ss.zzz);if(!query.prepare(update public.test_tz set ntz2ts ?, ntz2tz ? where test_name ?;))throwquery.lastError().text();query.addBindValue(textDate);if(str_insert)query.addBindValue(textDate);elsequery.addBindValue(dtmVal);query.addBindValue(name);if(!query.exec())throwquery.lastError().text();}}voidselect_table(QSqlQueryquery){constQString sqlselect * from public.test_tz order by test_name ASC;;stout\nsql\n;if(!query.exec(sql))throwquery.lastError().text();inti0;while(query.next()){constintcountquery.record().count();if(i0){stout\n\n|;for(inti0;icount;i)stoutquery.record().fieldName(i)|;stout\n|;for(inti0;icount;i)stout---|;}stout\n|;for(inti0;icount;i){stoutquery.record().value(i).toString();stout|;}stout.flush();i;}stout\n;stout.flush();}voidquery_data(QDateTimedtmobj,QSqlQueryquery,QString field_name,boolusingstr,boolstr_usingtz){constQString sqlQString(select test_name, %1 from public.test_tz where %1 ? order by test_name asc;).arg(field_name);stout\nsql\n;// 获取当前系统时区constQString tz_osQTimeZone::systemTimeZone().id();// 获取会话时区if(!query.exec(show timezone;))throwquery.lastError().text();if(!query.next())throwQString(\nError. Can not get session timezone.\n);constQString tz_sqlquery.value(0).toString();//获取来源时区、来源的字符串constQString tz_srcdtmobj.timeZone().id();constQString src_strstr_usingtz?dtmobj.toString(yyyy-MM-ddTHH:mm:ss.zzzt):dtmobj.toString(yyyy-MM-dd HH:mm:ss.zzz);constqint64 src_utcdtmobj.toSecsSinceEpoch();stoutOS tz_os, Session tz_sql, QDateTime tz_src,;stout Query field_name using src_str , utc src_utc, operation ;//selectif(!query.prepare(sql))throwquery.lastError().text();if(usingstr){stout(str_usingtz?QStringzone:QString);query.addBindValue(src_str);}else{stoutQDateTime object;query.addBindValue(dtmobj);}if(!query.exec())throwquery.lastError().text();inti0;while(query.next()){constintcountquery.record().count();if(i0){stout\n\n|;for(inti0;icount;i)stoutquery.record().fieldName(i)|;stout\n|;for(inti0;icount;i)stout---|;}stout\n|;for(inti0;icount;i){stoutquery.record().value(i).toString();stout|;}stout.flush();i;}stout\n\n;}5. 产生数据内容分别设置操作系统时区为北京时刻、芝加哥时刻、伦敦时刻反复运行上述程序3次得到完整的数据表如下test_nametz_ostz_sqltz_srcsrc_strsrc_utcopr_typedata_tzdata_ntzntz2tsntz2tztz2ntstz2ntzL0DAmerica/ChicagoAmerica/ChicagoUTCAmerica/Chicago2025-01-01T00:00:00.000GMT-61735711200QDateTime2025-01-01T00:00:00.000-06:002025-01-01T06:00:00.000Z2025-01-01T06:00:00.000Z2025-01-01T00:00:00.000-06:002025-01-01T06:00:00.000Z2025-01-01T06:00:00.000ZL0DAsia/ShanghaiAsia/ShanghaiUTCAsia/Shanghai2025-01-01T00:00:00.000GMT81735660800QDateTime2024-12-31T10:00:00.000-06:002024-12-31T16:00:00.000Z2024-12-31T16:00:00.000Z2024-12-31T10:00:00.000-06:002024-12-31T16:00:00.000Z2024-12-31T16:00:00.000ZL0DEtc/UTCEtc/UTCUTCEtc/UTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZL0SAmerica/ChicagoAmerica/ChicagoUTCAmerica/Chicago2025-01-01 00:00:00.0001735711200QString2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T18:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL0SAsia/ShanghaiAsia/ShanghaiUTCAsia/Shanghai2025-01-01 00:00:00.0001735660800QString2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T18:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL0SEtc/UTCEtc/UTCUTCEtc/UTC2025-01-01 00:00:00.0001735689600QString2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T18:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL0ZAmerica/ChicagoAmerica/ChicagoUTCAmerica/Chicago2025-01-01T00:00:00.000GMT-61735711200QStringzone2024-12-31T12:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000Z2024-12-31T18:00:00.000ZL0ZAsia/ShanghaiAsia/ShanghaiUTCAsia/Shanghai2025-01-01T00:00:00.000GMT81735660800QStringzone2025-01-01T02:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.000Z2025-01-01T08:00:00.000ZL0ZEtc/UTCEtc/UTCUTCEtc/UTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZL6DAmerica/ChicagoAmerica/ChicagoAmerica/ChicagoAmerica/Chicago2025-01-01T00:00:00.000GMT-61735711200QDateTime2025-01-01T00:00:00.000-06:002025-01-01T06:00:00.000Z2025-01-01T06:00:00.000Z2025-01-01T00:00:00.000-06:002025-01-01T00:00:00.000-06:002025-01-01T06:00:00.000ZL6DAsia/ShanghaiAsia/ShanghaiAmerica/ChicagoAsia/Shanghai2025-01-01T00:00:00.000GMT81735660800QDateTime2024-12-31T10:00:00.000-06:002024-12-31T16:00:00.000Z2024-12-31T16:00:00.000Z2024-12-31T10:00:00.000-06:002024-12-31T10:00:00.000-06:002024-12-31T16:00:00.000ZL6DEtc/UTCEtc/UTCAmerica/ChicagoEtc/UTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000ZL6SAmerica/ChicagoAmerica/ChicagoAmerica/ChicagoAmerica/Chicago2025-01-01 00:00:00.0001735711200QString2025-01-01T00:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002025-01-01T00:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL6SAsia/ShanghaiAsia/ShanghaiAmerica/ChicagoAsia/Shanghai2025-01-01 00:00:00.0001735660800QString2025-01-01T00:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002025-01-01T00:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL6SEtc/UTCEtc/UTCAmerica/ChicagoEtc/UTC2025-01-01 00:00:00.0001735689600QString2025-01-01T00:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002025-01-01T00:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL6ZAmerica/ChicagoAmerica/ChicagoAmerica/ChicagoAmerica/Chicago2025-01-01T00:00:00.000GMT-61735711200QStringzone2024-12-31T12:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T12:00:00.000-06:002024-12-31T12:00:00.000ZL6ZAsia/ShanghaiAsia/ShanghaiAmerica/ChicagoAsia/Shanghai2025-01-01T00:00:00.000GMT81735660800QStringzone2025-01-01T02:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T02:00:00.000-06:002025-01-01T02:00:00.000ZL6ZEtc/UTCEtc/UTCAmerica/ChicagoEtc/UTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000ZL8DAmerica/ChicagoAmerica/ChicagoAsia/ShanghaiAmerica/Chicago2025-01-01T00:00:00.000GMT-61735711200QDateTime2025-01-01T00:00:00.000-06:002025-01-01T06:00:00.000Z2025-01-01T06:00:00.000Z2025-01-01T00:00:00.000-06:002025-01-01T14:00:00.00008:002025-01-01T06:00:00.000ZL8DAsia/ShanghaiAsia/ShanghaiAsia/ShanghaiAsia/Shanghai2025-01-01T00:00:00.000GMT81735660800QDateTime2024-12-31T10:00:00.000-06:002024-12-31T16:00:00.000Z2024-12-31T16:00:00.000Z2024-12-31T10:00:00.000-06:002025-01-01T00:00:00.00008:002024-12-31T16:00:00.000ZL8DEtc/UTCEtc/UTCAsia/ShanghaiEtc/UTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T00:00:00.000ZL8SAmerica/ChicagoAmerica/ChicagoAsia/ShanghaiAmerica/Chicago2025-01-01 00:00:00.0001735711200QString2024-12-31T10:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T10:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL8SAsia/ShanghaiAsia/ShanghaiAsia/ShanghaiAsia/Shanghai2025-01-01 00:00:00.0001735660800QString2024-12-31T10:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T10:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL8SEtc/UTCEtc/UTCAsia/ShanghaiEtc/UTC2025-01-01 00:00:00.0001735689600QString2024-12-31T10:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T10:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZL8ZAmerica/ChicagoAmerica/ChicagoAsia/ShanghaiAmerica/Chicago2025-01-01T00:00:00.000GMT-61735711200QStringzone2024-12-31T12:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T02:00:00.00008:002025-01-01T02:00:00.000ZL8ZAsia/ShanghaiAsia/ShanghaiAsia/ShanghaiAsia/Shanghai2025-01-01T00:00:00.000GMT81735660800QStringzone2025-01-01T02:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T16:00:00.00008:002025-01-01T16:00:00.000ZL8ZEtc/UTCEtc/UTCAsia/ShanghaiEtc/UTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T08:00:00.000ZU0DAmerica/ChicagoAmerica/ChicagoUTCUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZU0DAsia/ShanghaiAsia/ShanghaiUTCUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZU0DEtc/UTCEtc/UTCUTCUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZU0SAmerica/ChicagoAmerica/ChicagoUTCUTC2025-01-01 00:00:00.0001735689600QString2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T18:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU0SAsia/ShanghaiAsia/ShanghaiUTCUTC2025-01-01 00:00:00.0001735689600QString2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T18:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU0SEtc/UTCEtc/UTCUTCUTC2025-01-01 00:00:00.0001735689600QString2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T18:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU0ZAmerica/ChicagoAmerica/ChicagoUTCUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZU0ZAsia/ShanghaiAsia/ShanghaiUTCUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZU0ZEtc/UTCEtc/UTCUTCUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000ZU6DAmerica/ChicagoAmerica/ChicagoAmerica/ChicagoUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000ZU6DAsia/ShanghaiAsia/ShanghaiAmerica/ChicagoUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000ZU6DEtc/UTCEtc/UTCAmerica/ChicagoUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000ZU6SAmerica/ChicagoAmerica/ChicagoAmerica/ChicagoUTC2025-01-01 00:00:00.0001735689600QString2025-01-01T00:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002025-01-01T00:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU6SAsia/ShanghaiAsia/ShanghaiAmerica/ChicagoUTC2025-01-01 00:00:00.0001735689600QString2025-01-01T00:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002025-01-01T00:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU6SEtc/UTCEtc/UTCAmerica/ChicagoUTC2025-01-01 00:00:00.0001735689600QString2025-01-01T00:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002025-01-01T00:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU6ZAmerica/ChicagoAmerica/ChicagoAmerica/ChicagoUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000ZU6ZAsia/ShanghaiAsia/ShanghaiAmerica/ChicagoUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000ZU6ZEtc/UTCEtc/UTCAmerica/ChicagoUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000-06:002024-12-31T18:00:00.000ZU8DAmerica/ChicagoAmerica/ChicagoAsia/ShanghaiUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T00:00:00.000ZU8DAsia/ShanghaiAsia/ShanghaiAsia/ShanghaiUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T00:00:00.000ZU8DEtc/UTCEtc/UTCAsia/ShanghaiUTC2025-01-01T00:00:00.000UTC1735689600QDateTime2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T00:00:00.000ZU8SAmerica/ChicagoAmerica/ChicagoAsia/ShanghaiUTC2025-01-01 00:00:00.0001735689600QString2024-12-31T10:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T10:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU8SAsia/ShanghaiAsia/ShanghaiAsia/ShanghaiUTC2025-01-01 00:00:00.0001735689600QString2024-12-31T10:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T10:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU8SEtc/UTCEtc/UTCAsia/ShanghaiUTC2025-01-01 00:00:00.0001735689600QString2024-12-31T10:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01 00:00:00.0002024-12-31T10:00:00.000-06:002025-01-01 00:00:00.0002025-01-01T00:00:00.000ZU8ZAmerica/ChicagoAmerica/ChicagoAsia/ShanghaiUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T08:00:00.000ZU8ZAsia/ShanghaiAsia/ShanghaiAsia/ShanghaiUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T08:00:00.000ZU8ZEtc/UTCEtc/UTCAsia/ShanghaiUTC2025-01-01T00:00:00.000UTC1735689600QStringzone2024-12-31T18:00:00.000-06:002025-01-01T00:00:00.000Z2025-01-01T00:00:00.000Z2024-12-31T18:00:00.000-06:002025-01-01T08:00:00.00008:002025-01-01T08:00:00.000Z6. 结果详细分析通过对测试数据的梳理和验证QtSql操作PostgreSQL时戳字段的行为受多重因素影响主要规律如下6.1 核心影响因素及作用机制时区层级的优先级时戳处理中存在三级时区影响优先级从高到低为字符串插入时显式携带的时区如2025-01-01T00:00:00.00008:00QDateTime对象自身绑定的时区通过QDateTime(..., QTimeZone)指定数据库会话时区通过set timezone xxx设置。操作系统时区tz_os仅影响未指定时区的QDateTime对象的默认时区此时QDateTime默认使用系统时区。插入操作的行为差异QDateTime对象插入Qt会自动将对象转换为数据库会话时区对应的时戳存储。例如当会话时区为America/ChicagoUTC-6时插入一个UTC时区的2025-01-01 00:00:00数据库会存储为2024-12-31 18:00:00-06:00带时区字段或2024-12-31 18:00:00不带时区字段。字符串插入不带时区数据库会按当前会话时区解析字符串。例如会话时区为Asia/ShanghaiUTC8时插入字符串2025-01-01 00:00:00会被解析为UTC8的该时刻对应UTC时间为2024-12-31 16:00:00。字符串插入带时区数据库直接按字符串中的时区解析不受会话时区影响。例如插入2025-01-01T00:00:00.000UTC无论会话时区如何均解析为UTC时间的该时刻。字段类型的存储特性timestamp with time zonedata_tz存储时会转换为UTC时间读取时根据会话时区转换为当地时间显示。例如存储的UTC时间2025-01-01 00:00:00在Asia/Shanghai会话时区下读取显示为2025-01-01 08:00:0008:00。timestamp without time zonedata_ntz直接存储字符串或QDateTime转换后的本地时间不含时区信息读取时不会进行时区转换。例如在America/Chicago会话时插入的2025-01-01 00:00:00读取时仍为该值与会话时区无关。时戳搬运字段间转换的规律data_tz转tz2ntz带时区转不带时区会将带时区时戳按当前会话时区转换为本地时间作为不带时区时戳存储。data_ntz转ntz2tz不带时区转带时区会将不带时区时戳按当前会话时区解析为带时区时戳即假设该时间为会话时区的本地时间。6.2 常见问题与风险点歧义性插入使用不带时区的字符串插入data_ntz字段时若会话时区变化相同字符串会被解析为不同UTC时间导致数据不一致。例如同样插入2025-01-01 00:00:00在UTC和Asia/Shanghai会话时区下对应UTC时间相差8小时。时区丢失data_ntz字段存储时丢失时区信息后续读取或转换时需依赖固定会话时区否则可能出现逻辑错误如跨时区查询时时间对比失准。Qt版本差异测试基于Qt6.10.1低版本Qt如Qt5.15以下可能存在时区转换逻辑差异需额外验证。6.3 query日期比较的行为规律与结果差异解析查询时的日期比较结果能否匹配到记录受查询条件格式、字段类型、会话时区及插入时的时区处理逻辑共同影响。结合测试数据具体规律如下6.3.1 能查询到结果的典型场景及原因查询条件与字段存储的UTC时间一致带时区字段对于data_tztimestamp with time zone字段其底层存储为UTC时间查询时会根据会话时区转换为本地时间进行匹配。当查询条件如QDateTime对象或带时区的字符串解析后的UTC时间与存储的UTC时间一致时可匹配到结果。例在“计算机为北京时间SessionAmerica/Chicago查询data_tz使用QDateTimeUTC2025-01-01 00:00:00”的场景中L0DAmerica/Chicago的data_tz字段存储的UTC时间为2025-01-01 06:00:00对应会话时区-06:00的本地时间2025-01-01 00:00:00与查询条件的UTC时间一致因此被匹配到见代码片段中L0DAmerica/Chicago的查询结果。查询条件与字段存储的本地时间一致不带时区字段对于data_ntztimestamp without time zone字段其存储的是插入时的本地时间无时区信息。当查询条件的本地时间按会话时区解析与存储的本地时间一致时可匹配到结果。例多个测试用例中data_ntz字段均存储为2025-01-01T00:00:00.000Z本地时间无论查询时的会话时区是Asia/Shanghai、America/Chicago还是UTC只要查询条件解析后的本地时间为2025-01-01 00:00:00即可匹配到所有相关记录如代码片段中多次出现的data_ntz查询结果。转换字段tz2ntz/ntz2tz的转换逻辑匹配tz2ntz字段由data_tz按会话时区转换为本地时间存储无时区。当查询tz2ntz时若条件为该本地时间如2025-01-01T00:00:00.000Z则所有符合转换逻辑的记录均可匹配见“计算机为芝加哥时间”的tz2ntz查询结果。ntz2tz字段由data_ntz按会话时区解析为带时区时间存储。当查询ntz2ntz时若条件的UTC时间与解析后的UTC时间一致则可匹配如代码片段中ntz2tz查询结果均为2024-12-31T18:00:00.000-06:00对应UTC时间一致。6.3.2 查不到结果的典型场景及原因查询条件与字段的时区解析逻辑冲突对data_tz字段使用不带时区的字符串查询时字符串会按当前会话时区解析为UTC时间。若该UTC时间与字段存储的UTC时间不一致则无法匹配。例若data_tz存储的UTC时间为2025-01-01 06:00:00对应会话时区America/Chicago的本地时间2025-01-01 00:00:00若查询时会话时区改为Asia/Shanghai不带时区的查询条件2025-01-01 00:00:00会被解析为UTC时间2024-12-31 16:00:00与存储值不一致导致查不到结果。不带时区字段的“隐性时区依赖”不匹配data_ntz字段存储时丢失时区信息查询时依赖会话时区解析条件。若查询时的会话时区与插入时的会话时区不同相同字符串条件会被解析为不同本地时间导致不匹配。例插入data_ntz时会话时区为UTC存储本地时间2025-01-01 00:00:00若查询时会话时区为Asia/Shanghai查询条件2025-01-01 00:00:00会被解析为UTC8的本地时间对应UTC时间2024-12-31 16:00:00与存储的本地时间UTC时区不一致无法匹配。转换字段的转换逻辑未被正确适配tz2ntz字段的值取决于data_tz转换时的会话时区。若查询时使用的条件未对应转换时的本地时间则无法匹配。例如若tz2ntz是data_tz在UTC时区下转换的本地时间2025-01-01 06:00:00而查询条件使用2025-01-01 00:00:00则无法匹配。ntz2tz字段的值取决于data_ntz解析时的会话时区。若查询条件的时区与解析时的会话时区不同导致UTC时间不匹配则查不到结果。6.3.3 核心结论查询能否匹配的本质是查询条件解析后的UTC时间带时区字段或本地时间不带时区字段与存储值是否一致。带时区字段的查询依赖“UTC时间对齐”不带时区字段的查询依赖“本地时间对齐会话时区一致”转换字段则需同时满足原始字段的处理逻辑和转换时的时区规则。7. 编程最佳规范建议基于上述测试结果为避免QtSql操作PostgreSQL时戳字段出现一致性问题建议遵循以下规范7.1 字段类型选择优先使用timestamp with time zone该类型自带时区信息存储和读取时会自动进行时区转换能最大程度避免跨时区场景下的歧义。仅在明确无需时区信息如纯本地时间记录时使用timestamp without time zone。7.2 插入操作规范推荐使用QDateTime对象插入创建QDateTime时需显式指定时区如QDateTime(..., QTimeZone::utc())避免依赖系统默认时区。例如QDateTimedtm(QDate(2025,1,1),QTime(0,0,0),QTimeZone::utc());// 明确UTC时区query.addBindValue(dtm);// 绑定到data_tz字段避免使用不带时区的字符串插入若必须使用字符串需携带明确时区信息如yyyy-MM-ddTHH:mm:ss.zzzt格式例如QString strdtm.toString(yyyy-MM-ddTHH:mm:ss.zzzt);// 含时区的字符串query.addBindValue(str);7.3 数据库会话配置统一数据库会话时区为UTC连接数据库后立即执行set timezone UTC;避免会话时区变化导致的转换差异。例如QSqlQueryquery(db);query.exec(set timezone UTC;);// 固定会话时区为UTC统一数据库会话时区为约定时区如连接数据库后立即执行set timezone Asia/Shanghai;避免会话时区变化导致的转换差异。例如QSqlQueryquery(db);query.exec(set timezone Asia/Shanghai;);// 固定会话时区为Asia/Shanghai7.4 读取与转换操作读取时显式指定目标时区从data_tz字段读取QDateTime后可通过toTimeZone()转换为业务所需时区避免依赖默认时区。例如QDateTime dtmquery.value(0).toDateTime();QDateTime shanghaiTimedtm.toTimeZone(QTimeZone(Asia/Shanghai));// 转换为上海时区data_ntz字段处理读取时需明确其原始插入时的会话时区必要时通过QDateTime::fromString手动指定时区解析例如QString ntzStrquery.value(0).toString();QDateTime dtmQDateTime::fromString(ntzStr,yyyy-MM-dd HH:mm:ss.zzz);dtm.setTimeZone(QTimeZone(UTC));// 假设原始插入时区为UTC7.5 测试与验证覆盖多时区场景测试用例需包含至少3种时区如UTC、Asia/Shanghai、America/Chicago验证插入、读取、转换的一致性。对比UTC时间戳通过QDateTime::toSecsSinceEpoch()将时戳转换为UTC秒数进行校验确保不同操作最终对应相同的UTC时刻。遵循以上规范可有效减少因时区、字段类型、插入方式导致的时戳不一致问题确保QtSql操作PostgreSQL时戳字段的可靠性。7.6 查询操作规范带时区字段data_tz查询优先使用带时区的QDateTime对象或含时区的字符串如yyyy-MM-ddTHH:mm:ss.zzzt作为条件确保查询条件的UTC时间与存储值一致。示例QDateTimequeryDt(QDate(2025,1,1),QTime(0,0,0),QTimeZone::utc());// 明确UTC时区query.prepare(select * from test_tz where data_tz ?);query.addBindValue(queryDt);避免使用不带时区的字符串若必须使用需确保会话时区与插入时一致。不带时区字段data_ntz查询必须明确字段插入时的会话时区查询时使用相同会话时区并以本地时间字符串或绑定对应时区的QDateTime作为条件需手动转换为插入时的本地时间。示例假设插入时会话时区为UTCQDateTimequeryDt(QDate(2025,1,1),QTime(0,0,0),QTimeZone::utc());// 插入时的本地时间query.prepare(select * from test_tz where data_ntz ?);query.addBindValue(queryDt.toString(yyyy-MM-dd HH:mm:ss.zzz));// 按本地时间字符串查询统一查询时区上下文执行查询前固定会话时区如set timezone UTC并确保查询条件的时区处理与该上下文一致避免跨查询的时区波动导致结果不一致。遵循以上查询规范可有效减少因条件格式、时区解析差异导致的“查不到结果”问题确保日期比较的准确性。附件 query_data 历次输出结果(1) 计算机为北京时间select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query data_tz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QDateTime objecttest_namedata_tzL0DAsia/Shanghai2024-12-31T10:00:00.000-06:00L6DAsia/Shanghai2024-12-31T10:00:00.000-06:00L8DAsia/Shanghai2024-12-31T10:00:00.000-06:00L8SAmerica/Chicago2024-12-31T10:00:00.000-06:00L8SAsia/Shanghai2024-12-31T10:00:00.000-06:00L8SEtc/UTC2024-12-31T10:00:00.000-06:00U8SAmerica/Chicago2024-12-31T10:00:00.000-06:00U8SAsia/Shanghai2024-12-31T10:00:00.000-06:00U8SEtc/UTC2024-12-31T10:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query data_tz using 2025-01-01 00:00:00.000 , utc 1735660800, operation QStringtest_namedata_tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query data_tz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QStringzonetest_namedata_tzL0ZAsia/Shanghai2025-01-01T02:00:00.000-06:00L6ZAsia/Shanghai2025-01-01T02:00:00.000-06:00L8ZAsia/Shanghai2025-01-01T02:00:00.000-06:00select test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query data_ntz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QDateTime objecttest_namedata_ntzL0DAsia/Shanghai2024-12-31T16:00:00.000ZL6DAsia/Shanghai2024-12-31T16:00:00.000ZL8DAsia/Shanghai2024-12-31T16:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query data_ntz using 2025-01-01 00:00:00.000 , utc 1735660800, operation QStringtest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query data_ntz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QStringzonetest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query ntz2tz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QDateTime objecttest_namentz2tzL0DAsia/Shanghai2024-12-31T10:00:00.000-06:00L6DAsia/Shanghai2024-12-31T10:00:00.000-06:00L8DAsia/Shanghai2024-12-31T10:00:00.000-06:00L8SAmerica/Chicago2024-12-31T10:00:00.000-06:00L8SAsia/Shanghai2024-12-31T10:00:00.000-06:00L8SEtc/UTC2024-12-31T10:00:00.000-06:00U8SAmerica/Chicago2024-12-31T10:00:00.000-06:00U8SAsia/Shanghai2024-12-31T10:00:00.000-06:00U8SEtc/UTC2024-12-31T10:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query ntz2tz using 2025-01-01 00:00:00.000 , utc 1735660800, operation QStringtest_namentz2tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query ntz2tz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QStringzoneselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query tz2ntz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QDateTime objecttest_nametz2ntzL0DAsia/Shanghai2024-12-31T16:00:00.000ZL6DAsia/Shanghai2024-12-31T16:00:00.000ZL8DAsia/Shanghai2024-12-31T16:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query tz2ntz using 2025-01-01 00:00:00.000 , utc 1735660800, operation QStringtest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime Asia/Shanghai, Query tz2ntz using 2025-01-01T00:00:00.000GMT8 , utc 1735660800, operation QStringzonetest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namentz2tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Asia/Shanghai, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Z(2) 计算机为UTC时间select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query data_tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query data_ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query ntz2tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namentz2tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query tz2ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime Etc/UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namentz2tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS Etc/UTC, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Z(3) 计算机为芝加哥时间select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query data_tz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QDateTime objecttest_namedata_tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query data_tz using 2025-01-01 00:00:00.000 , utc 1735711200, operation QStringtest_namedata_tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query data_tz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QStringzonetest_namedata_tzL0ZAmerica/Chicago2024-12-31T12:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T12:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T12:00:00.000-06:00select test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query data_ntz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QDateTime objecttest_namedata_ntzL0DAmerica/Chicago2025-01-01T06:00:00.000ZL6DAmerica/Chicago2025-01-01T06:00:00.000ZL8DAmerica/Chicago2025-01-01T06:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query data_ntz using 2025-01-01 00:00:00.000 , utc 1735711200, operation QStringtest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query data_ntz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QStringzonetest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query ntz2tz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QDateTime objecttest_namentz2tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query ntz2tz using 2025-01-01 00:00:00.000 , utc 1735711200, operation QStringtest_namentz2tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query ntz2tz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QStringzoneselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query tz2ntz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QDateTime objecttest_nametz2ntzL0DAmerica/Chicago2025-01-01T06:00:00.000ZL6DAmerica/Chicago2025-01-01T06:00:00.000ZL8DAmerica/Chicago2025-01-01T06:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query tz2ntz using 2025-01-01 00:00:00.000 , utc 1735711200, operation QStringtest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime America/Chicago, Query tz2ntz using 2025-01-01T00:00:00.000GMT-6 , utc 1735711200, operation QStringzonetest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, data_tz from public.test_tz where data_tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query data_tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, data_ntz from public.test_tz where data_ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query data_ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namedata_ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZAmerica/Chicago2025-01-01T00:00:00.000ZL0ZAsia/Shanghai2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL6ZAmerica/Chicago2025-01-01T00:00:00.000ZL6ZAsia/Shanghai2025-01-01T00:00:00.000ZL6ZEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZL8ZAmerica/Chicago2025-01-01T00:00:00.000ZL8ZAsia/Shanghai2025-01-01T00:00:00.000ZL8ZEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU6ZAmerica/Chicago2025-01-01T00:00:00.000ZU6ZAsia/Shanghai2025-01-01T00:00:00.000ZU6ZEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000ZU8ZAmerica/Chicago2025-01-01T00:00:00.000ZU8ZAsia/Shanghai2025-01-01T00:00:00.000ZU8ZEtc/UTC2025-01-01T00:00:00.000Zselect test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_namentz2tzL0DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6DAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAmerica/Chicago2025-01-01T00:00:00.000-06:00L6SAsia/Shanghai2025-01-01T00:00:00.000-06:00L6SEtc/UTC2025-01-01T00:00:00.000-06:00L8DAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAmerica/Chicago2025-01-01T00:00:00.000-06:00U6SAsia/Shanghai2025-01-01T00:00:00.000-06:00U6SEtc/UTC2025-01-01T00:00:00.000-06:00select test_name, ntz2tz from public.test_tz where ntz2tz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query ntz2tz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_namentz2tzL0DEtc/UTC2024-12-31T18:00:00.000-06:00L0SAmerica/Chicago2024-12-31T18:00:00.000-06:00L0SAsia/Shanghai2024-12-31T18:00:00.000-06:00L0SEtc/UTC2024-12-31T18:00:00.000-06:00L0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L0ZEtc/UTC2024-12-31T18:00:00.000-06:00L6DEtc/UTC2024-12-31T18:00:00.000-06:00L6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L6ZEtc/UTC2024-12-31T18:00:00.000-06:00L8DEtc/UTC2024-12-31T18:00:00.000-06:00L8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00L8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00L8ZEtc/UTC2024-12-31T18:00:00.000-06:00U0DAmerica/Chicago2024-12-31T18:00:00.000-06:00U0DAsia/Shanghai2024-12-31T18:00:00.000-06:00U0DEtc/UTC2024-12-31T18:00:00.000-06:00U0SAmerica/Chicago2024-12-31T18:00:00.000-06:00U0SAsia/Shanghai2024-12-31T18:00:00.000-06:00U0SEtc/UTC2024-12-31T18:00:00.000-06:00U0ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U0ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U0ZEtc/UTC2024-12-31T18:00:00.000-06:00U6DAmerica/Chicago2024-12-31T18:00:00.000-06:00U6DAsia/Shanghai2024-12-31T18:00:00.000-06:00U6DEtc/UTC2024-12-31T18:00:00.000-06:00U6ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U6ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U6ZEtc/UTC2024-12-31T18:00:00.000-06:00U8DAmerica/Chicago2024-12-31T18:00:00.000-06:00U8DAsia/Shanghai2024-12-31T18:00:00.000-06:00U8DEtc/UTC2024-12-31T18:00:00.000-06:00U8ZAmerica/Chicago2024-12-31T18:00:00.000-06:00U8ZAsia/Shanghai2024-12-31T18:00:00.000-06:00U8ZEtc/UTC2024-12-31T18:00:00.000-06:00select test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QDateTime objecttest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01 00:00:00.000 , utc 1735689600, operation QStringtest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Zselect test_name, tz2ntz from public.test_tz where tz2ntz ? order by test_name asc;OS America/Chicago, Session America/Chicago, QDateTime UTC, Query tz2ntz using 2025-01-01T00:00:00.000UTC , utc 1735689600, operation QStringzonetest_nametz2ntzL0DEtc/UTC2025-01-01T00:00:00.000ZL0SAmerica/Chicago2025-01-01T00:00:00.000ZL0SAsia/Shanghai2025-01-01T00:00:00.000ZL0SEtc/UTC2025-01-01T00:00:00.000ZL0ZEtc/UTC2025-01-01T00:00:00.000ZL6DEtc/UTC2025-01-01T00:00:00.000ZL6SAmerica/Chicago2025-01-01T00:00:00.000ZL6SAsia/Shanghai2025-01-01T00:00:00.000ZL6SEtc/UTC2025-01-01T00:00:00.000ZL8DEtc/UTC2025-01-01T00:00:00.000ZL8SAmerica/Chicago2025-01-01T00:00:00.000ZL8SAsia/Shanghai2025-01-01T00:00:00.000ZL8SEtc/UTC2025-01-01T00:00:00.000ZU0DAmerica/Chicago2025-01-01T00:00:00.000ZU0DAsia/Shanghai2025-01-01T00:00:00.000ZU0DEtc/UTC2025-01-01T00:00:00.000ZU0SAmerica/Chicago2025-01-01T00:00:00.000ZU0SAsia/Shanghai2025-01-01T00:00:00.000ZU0SEtc/UTC2025-01-01T00:00:00.000ZU0ZAmerica/Chicago2025-01-01T00:00:00.000ZU0ZAsia/Shanghai2025-01-01T00:00:00.000ZU0ZEtc/UTC2025-01-01T00:00:00.000ZU6DAmerica/Chicago2025-01-01T00:00:00.000ZU6DAsia/Shanghai2025-01-01T00:00:00.000ZU6DEtc/UTC2025-01-01T00:00:00.000ZU6SAmerica/Chicago2025-01-01T00:00:00.000ZU6SAsia/Shanghai2025-01-01T00:00:00.000ZU6SEtc/UTC2025-01-01T00:00:00.000ZU8DAmerica/Chicago2025-01-01T00:00:00.000ZU8DAsia/Shanghai2025-01-01T00:00:00.000ZU8DEtc/UTC2025-01-01T00:00:00.000ZU8SAmerica/Chicago2025-01-01T00:00:00.000ZU8SAsia/Shanghai2025-01-01T00:00:00.000ZU8SEtc/UTC2025-01-01T00:00:00.000Z