How to get the list of timezones supported by postgresql?

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

How to get the list of timezones supported by postgresql?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by dedrick , 9 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.

Related Threads:

How to list tables in PostgreSQL?
How to get the list of pm2 in laravel?
How to get users list in codeigniter?
How to get list of all auth0 users?
How to get list of order id in woocommerce?
How to get a list of country codes in woocommerce?