How to get the list of timezones supported by postgresql?

by hal.littel , in category: MySQL , 7 months ago

How to get the list of timezones supported by postgresql?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by dedrick , 7 months ago

@hal.littel 

To get the list of timezones supported by PostgreSQL, you can use the following SQL query:

1
2
SELECT name
FROM pg_timezone_names;


Running this query will return a list of all timezones supported by PostgreSQL.