Can anyone help me with the query to find Time Zone used in Post gre sql?
To get the time zone, run this command in PGAdmin or the psql console.
If you wish to know the UTC + or - value, run
SELECT EXTRACT(TIMEZONE FROM now())/3600.0;
Also see PostgreSQL timezone does not match system timezone - Server Fault
Please lets us know if the replies were helpful and has correctly answered your question, If so, please click the "Mark Correct" button so others can benefit from this information.
I see no additional updates to the proposed solution. So marking as answered. You may provide additional posts as needed. Thanks
Sorry for the delay, yes the Command "SELECT current_setting('TIMEZONE');" worked. Thank you Matt.
Retrieving data ...