timezone feature does not work as expected

[localvar]

Describe the bug（Bug 描述）

I trie to use timezone 'Asia/Shanghai' and 'America/Chicago' but the returned timestamp are all the same.

To Reproduce（Bug 复现步骤）

> use db0
> insert cpu,host=server-01,region=east-cn disk=10i,memory=100i,network=1243i
> insert cpu,host=server-01,region=east-cn disk=132i,memory=214i,network=513i
> select * from cpu
name: cpu
+---------------------+------+-----------+--------+---------+---------+
|        time         | disk |   host    | memory | network | region  |
+---------------------+------+-----------+--------+---------+---------+
| 1709515227157434300 |   10 | server-01 |    100 |    1243 | east-cn |
| 1709515248896036100 |  132 | server-01 |    214 |     513 | east-cn |
+---------------------+------+-----------+--------+---------+---------+
6 columns, 2 rows in set

> select * from cpu tz('Asia/Shanghai')
name: cpu
+---------------------+------+-----------+--------+---------+---------+
|        time         | disk |   host    | memory | network | region  |
+---------------------+------+-----------+--------+---------+---------+
| 1709515227157434300 |   10 | server-01 |    100 |    1243 | east-cn |
| 1709515248896036100 |  132 | server-01 |    214 |     513 | east-cn |
+---------------------+------+-----------+--------+---------+---------+
6 columns, 2 rows in set

> select * from cpu tz('America/Chicago')
name: cpu
+---------------------+------+-----------+--------+---------+---------+
|        time         | disk |   host    | memory | network | region  |
+---------------------+------+-----------+--------+---------+---------+
| 1709515227157434300 |   10 | server-01 |    100 |    1243 | east-cn |
| 1709515248896036100 |  132 | server-01 |    214 |     513 | east-cn |
+---------------------+------+-----------+--------+---------+---------+
6 columns, 2 rows in set

Expected behavior（期望结果）

No response

Screenshots（屏幕截图）

No response

Logs（完整的错误日志）

No response

Additional context（其他的一些补充内容）

No response

[xiangyu5632]

the returned timestamp must be in RFC3339 format for the UTC offset to appear.
set rfc3339 format

> precision rfc3339

please have a try.

[localvar]

@xiangyu5632

same result, always UTC+0, and the example in this document is using timestamp, not rfc3339.

> select * from cpu
name: cpu
+------------------------------+------+-----------+--------+---------+---------+
|             time             | disk |   host    | memory | network | region  |
+------------------------------+------+-----------+--------+---------+---------+
| 2024-03-04T01:20:27.1574343Z |   10 | server-01 |    100 |    1243 | east-cn |
| 2024-03-04T01:20:48.8960361Z |  132 | server-01 |    214 |     513 | east-cn |
+------------------------------+------+-----------+--------+---------+---------+
6 columns, 2 rows in set

>  select * from cpu tz('Asia/Shanghai')
name: cpu
+------------------------------+------+-----------+--------+---------+---------+
|             time             | disk |   host    | memory | network | region  |
+------------------------------+------+-----------+--------+---------+---------+
| 2024-03-04T01:20:27.1574343Z |   10 | server-01 |    100 |    1243 | east-cn |
| 2024-03-04T01:20:48.8960361Z |  132 | server-01 |    214 |     513 | east-cn |
+------------------------------+------+-----------+--------+---------+---------+
6 columns, 2 rows in set

> select * from cpu tz('America/Chicago')
name: cpu
+------------------------------+------+-----------+--------+---------+---------+
|             time             | disk |   host    | memory | network | region  |
+------------------------------+------+-----------+--------+---------+---------+
| 2024-03-04T01:20:27.1574343Z |   10 | server-01 |    100 |    1243 | east-cn |
| 2024-03-04T01:20:48.8960361Z |  132 | server-01 |    214 |     513 | east-cn |
+------------------------------+------+-----------+--------+---------+---------+
6 columns, 2 rows in set

[xiangyu5632]

right, it's really a bug