How to create custom time zone in PostgreSQL?

Question

I need a time zone which UTC+02:00 in winter time and switch to summer time (UTC+03:00) at first Sunday of March and switch back at first Sunday of November (the same as American DST rule).

All city I found in PostgreSQL database switch to UTC+03:00 at last Sunday of October and switch back UTC+02:00 at last Sunday of March

Which operating system are you using?

user330315
– user330315

2020-01-28 08:16:56 +00:00
Commented Jan 28, 2020 at 8:16 — user330315
– user330315, Commented Jan 28, 2020 at 8:16

Laurenz Albe · Accepted Answer · 2020-01-28 09:40:54Z

2

PostgreSQL gets its time zone information from the IANA Time Zone Database, either the version installed on your operating system, or a private copy owned by PostgreSQL. Which one is used depends on how PostgreSQL was configured at build time (look for --with-system-tzdata in the output of pg_config --configure).

To add a new time zone, you'd have to modify that time zone database. The Wikipedia page has an introduction to the format and the procedure.

answered Jan 28, 2020 at 9:40

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create custom time zone in PostgreSQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related