Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SHOW TIMEZONE;

TimeZone

GB

SHOW

SET TIMEZONE='Etc/UTC';
SHOW TIMEZONE;
SELECT to_char('2021-11-02T19:00:00.000Z'::timestamptz, 'DD.MM'); 

SET

TimeZone

Etc/UTC

SHOW

to_char

02.11

SELECT 1

SET TIMEZONE = 'Asia/Yekaterinburg';
SHOW TIMEZONE;
SELECT to_char('2021-11-02T19:00:00.000Z'::timestamptz, 'DD.MM'); 

SET

TimeZone

Asia/Yekaterinburg

SHOW

to_char

03.11

SELECT 1