DX Application Performance Management

  • Private Community

  • 1.  How to find time zone used by Postgre sql?

    Posted Dec 16, 2016 06:13 AM

    Hi All,

     

    Can anyone help me with the query to find Time Zone used in Post gre sql?

     

    Regards,

    Chandrasekhar.



  • 2.  Re: How to find time zone used by Postgre sql?
    Best Answer

    Broadcom Employee
    Posted Dec 16, 2016 08:52 AM

    Hi Chandrasekhar,

     

    To get the time zone, run this command in PGAdmin or the psql console.

     

    SELECT current_setting('TIMEZONE');

     

    If you wish to know the UTC + or - value, run

     

    SELECT EXTRACT(TIMEZONE FROM now())/3600.0;

     

    Thanks,

    Matt



  • 3.  Re: How to find time zone used by Postgre sql?

    Broadcom Employee
    Posted Dec 16, 2016 09:53 AM

    Also see PostgreSQL timezone does not match system timezone - Server Fault 



  • 4.  Re: How to find time zone used by Postgre sql?

    Broadcom Employee
    Posted Dec 16, 2016 10:07 AM

    Dear Chandrasekhar

      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.

     

    Thanks

    Hal German



  • 5.  Re: How to find time zone used by Postgre sql?

    Broadcom Employee
    Posted Dec 19, 2016 08:58 AM

    Dear Chandrasekhar,

     

    I see no additional updates to the proposed solution. So marking as answered. You may provide additional posts as needed. Thanks

    Gal German



  • 6.  Re: How to find time zone used by Postgre sql?

    Posted Dec 26, 2016 02:59 AM

    Hi HAl,

     

    Sorry for the delay, yes the Command "SELECT current_setting('TIMEZONE');" worked.  Thank you Matt.

     

    musma03Regards,

    Chandrasekhar.