How to find timezone info
Commands to find timezone information
postgresql configurationintermediate
by MYSQL
13 views
📋Steps in this guide1/1
1
How to find timezone info
Commands to find timezone information
Code/Command (click line numbers to comment):
1234567891011121314151617
dbaclass=#
show timezone
TimeZone
--------------
Asia/Kolkata
(1 row)
dbaclass=#
SELECT current_setting('TIMEZONE');
current_setting
-----------------
Asia/Kolkata
dbaclass=#
select name,setting,short_desc,boot_val from pg_settings where name='TimeZone';
name   | setting   | short_desc                           | boot_val
----------+--------------+-----------------------------------------------------------------+----------
TimeZone | Asia/Kolkata | Sets the time zone for displaying and interpreting time stamps. | GMT
(1 row)Comments (0)
Please to add comments
No comments yet. Be the first to comment!