How to set timezone

[plumk97]

My database is in Japan and Motor Admin also deployed in Japan server

But the time in the returned data is in the zero timezone

This causes the time zone displayed by my browser to be 9 hours ahead

I set some common timezone parameters for DSN url such as timezone=+09:00 and serverTimezone=+09:00 but they don't work

The result of run select now():

{
    "data": [
        [
            "2024-03-10T10:17:51.000Z"
        ]
    ],
    "meta": {
        "columns": [
            {
                "name": "now()",
                "display_name": "Now()",
                "column_type": "datetime",
                "is_array": false
            }
        ]
    }
}

The result of run select @@global.time_zone, @@session.time_zone:

{
    "data": [
        [
            "+09:00",
            "+09:00"
        ]
    ],
    "meta": {
        "columns": [
            {
                "name": "@@global.time_zone",
                "display_name": "@@global.time zone",
                "column_type": "string",
                "is_array": false
            },
            {
                "name": "@@session.time_zone",
                "display_name": "@@session.time zone",
                "column_type": "string",
                "is_array": false
            }
        ]
    }
}