给定一个timestamp with time zone，您可以通过以下命令获得当时德国的当前日期

SELECT date(current_timestamp AT TIME ZONE 'Europe/Berlin');

字符串
您的示例使用了timestamp without time zone，这可能就是问题所在。

你可以这样做

SELECT (timestamp '2023-08-01' AT TIME ZONE 'Europe/Berlin')::date;

To apply it on your accounting data, use this

    SELECT
        (myTimeStampColumnName AT TIME ZONE 'Europe/Berlin')::date
        FROM
        my_accounting_table_name;

Please change `myTimeStampColumnName` with your actual Attribute Name holding the `TimeStamp` data and `my_accounting_table_name` with the actual Table Name of the parent `myTimeStampColumnName`.

字符串
要进行分组/求和，请使用以下方法

SELECT
    (myTimeStampColumnName AT TIME ZONE 'Europe/Berlin')::date AS europe_berlin_date,
    SUM(amount) AS total_amount
FROM
    my_accounting_table_name
GROUP BY
    (myTimeStampColumnName AT TIME ZONE 'Europe/Berlin')::date;

型
希望这就是你正在寻找的。