Open
Description
Describe the bug
I use the PostgreSQL MCP service to connect to my database, and when calling the PostgreSQL MCP service, I get the following results:
{
"params": {
"sql": "SELECT "Date" AT TIME ZONE 'Asia/Shanghai' AS "本地日期", "numbers" AS "产量" FROM "ProductInspection" WHERE date_part('month', "Date") = 3 AND date_part('year', "Date") = 2025;"
},
"response": {
"content": [
{
"type": "text",
"text": "[\n {\n "本地日期": "2025-02-28T16:00:00.000Z",\n "产量": 100\n },\n {\n "本地日期": "2025-03-01T16:00:00.000Z",\n "产量": 200\n },\n {\n "本地日期": "2025-03-02T16:00:00.000Z",\n "产量": 300\n },\n {\n "本地日期": "2025-03-03T16:00:00.000Z",\n "产量": 400\n },\n {\n "本地日期": "2025-03-04T16:00:00.000Z",\n "产量": 500\n },\n {\n "本地日期": "2025-03-05T16:00:00.000Z",\n "产量": 600\n },\n {\n "本地日期": "2025-03-06T16:00:00.000Z",\n "产量": 700\n },\n {\n "本地日期": "2025-03-07T16:00:00.000Z",\n "产量": 800\n },\n {\n "本地日期": "2025-03-08T16:00:00.000Z",\n "产量": 900\n },\n {\n "本地日期": "2025-03-09T16:00:00.000Z",\n "产量": 1000\n },\n {\n "本地日期": "2025-03-10T16:00:00.000Z",\n "产量": 1100\n },\n {\n "本地日期": "2025-03-11T16:00:00.000Z",\n "产量": 1200\n },\n {\n "本地日期": "2025-03-12T16:00:00.000Z",\n "产量": 1300\n },\n {\n "本地日期": "2025-03-13T16:00:00.000Z",\n "产量": 1400\n },\n {\n "本地日期": "2025-03-14T16:00:00.000Z",\n "产量": 1500\n },\n {\n "本地日期": "2025-03-15T16:00:00.000Z",\n "产量": 1600\n },\n {\n "本地日期": "2025-03-16T16:00:00.000Z",\n "产量": 1700\n },\n {\n "本地日期": "2025-03-17T16:00:00.000Z",\n "产量": 1800\n },\n {\n "本地日期": "2025-03-18T16:00:00.000Z",\n "产量": 1900\n },\n {\n "本地日期": "2025-03-19T16:00:00.000Z",\n "产量": 2000\n },\n {\n "本地日期": "2025-03-20T16:00:00.000Z",\n "产量": 2100\n },\n {\n "本地日期": "2025-03-21T16:00:00.000Z",\n "产量": 2200\n },\n {\n "本地日期": "2025-03-22T16:00:00.000Z",\n "产量": 2300\n },\n {\n "本地日期": "2025-03-23T16:00:00.000Z",\n "产量": 2400\n },\n {\n "本地日期": "2025-03-24T16:00:00.000Z",\n "产量": 2500\n },\n {\n "本地日期": "2025-03-25T16:00:00.000Z",\n "产量": 2600\n },\n {\n "本地日期": "2025-03-26T16:00:00.000Z",\n "产量": 2700\n },\n {\n "本地日期": "2025-03-27T16:00:00.000Z",\n "产量": 2800\n },\n {\n "本地日期": "2025-03-28T16:00:00.000Z",\n "产量": 2900\n },\n {\n "本地日期": "2025-03-29T16:00:00.000Z",\n "产量": 3000\n },\n {\n "本地日期": "2025-03-30T16:00:00.000Z",\n "产量": 3100\n }\n]"
}
],
"isError": false
}
}
The local date is in UTC format, but my local time is:
postgres=# show timezone;
TimeZone
Asia/Shanghai
(1 行记录)
Why does this happen? How can I solve this problem?