adnanhamdussalam opened a new issue, #1670:
URL: https://github.com/apache/cloudberry/issues/1670
Hi,
as we have daylight saving activity it was done at OS level but after that I
am facing database time difference of one hour.
Database:
select now();
now
-------------------------------
2026-04-09 06:32:42.591684-05
show time zone;
TimeZone
---------------------
America/Mexico_City
OS:
timedatectl
Local time: Thu 2026-04-09 05:33:03 CST
Universal time: Thu 2026-04-09 11:33:03 UTC
RTC time: Thu 2026-04-09 11:33:03
Time zone: America/Mexico_City (CST, -0600)
After checking with the below query I am unable to find CST against time
zone "America/Mexico_City"
select *from pg_timezone_names where abbrev='CST';
name | abbrev | utc_offset | is_dst
-----------------------+--------+------------+--------
ROC | CST | 08:00:00 | f
PRC | CST | 08:00:00 | f
Asia/Taipei | CST | 08:00:00 | f
Asia/Macao | CST | 08:00:00 | f
Asia/Macau | CST | 08:00:00 | f
Asia/Chongqing | CST | 08:00:00 | f
Asia/Chungking | CST | 08:00:00 | f
Asia/Harbin | CST | 08:00:00 | f
Asia/Shanghai | CST | 08:00:00 | f
Canada/Saskatchewan | CST | -06:00:00 | f
America/Regina | CST | -06:00:00 | f
America/Swift_Current | CST | -06:00:00 | f
America/Belize | CST | -06:00:00 | f
America/Costa_Rica | CST | -06:00:00 | f
America/El_Salvador | CST | -06:00:00 | f
America/Guatemala | CST | -06:00:00 | f
America/Tegucigalpa | CST | -06:00:00 | f
America/Managua | CST | -06:00:00 | f
I am using coordinator Cloudberry Version: 'PostgreSQL 14.4 (Apache
Cloudberry 2.0.0-incubating build 1)
Need your support in this regard.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
