Feedback-ID: i76984098:Fastmail
Message-ID: <83c8ab4b-7b34-4b89-911d-61f38fccb9e7@aklaver.com>
Date: Tue, 9 Apr 2024 09:58:34 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Issue with date/timezone conversion function
To: Lok P <loknath.73@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
References: <CAKna9VY+_b3Cf=BEopo9Z6XcEPsaXSsUUaLJ48YMSMbqT+cSug@mail.gmail.com>
 <fbb258ef-f021-4048-8128-3f3c39491696@aklaver.com>
 <CAKna9VbDkD8FAkeF4jGXCvG7VA9j9FqyjKj9-f0UAj5m=8GZVw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAKna9VbDkD8FAkeF4jGXCvG7VA9j9FqyjKj9-f0UAj5m=8GZVw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/83c8ab4b-7b34-4b89-911d-61f38fccb9e7%40aklaver.com>
Precedence: bulk


On 4/9/24 9:16 AM, Lok P wrote:
> 
> On Tue, Apr 9, 2024 at 9:26 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 4/9/24 08:43, Lok P wrote:
>      > Hi All,
>      > It's version 15.4 of postgresql database. Every "date/time" data
>     type
>      > attribute gets stored in the database in UTC timezone only. One
>     of the
>      > support persons local timezone is "asia/kolkata" and  that support
>      > person needs to fetch the count of transactions from a table-
>      > transaction_tab and share it with another person/customer who is
>     in the
>      > EST timezone, so basically the transaction has to be shown or
>     displayed
>      > the EST timezone.
> 
>     What is the datatype for the create_timestamp?
> 
>     What does SHOW timezone; return on the server?
> 
> 
> 
> Thank you for the quick response.
> 
> The column data type for "create_timestamp" is "timestamptz'.
> Show timezone from the support users client machine UI showing  
> "Asia/Calcutta".
> Not having access to run "Show timezone" on the server currently, I will 
> try to get it.
> output from pg_setting showing setting as "Asia/Calcutta', reset_val as 
> "Asia/Calcutta", boot_val as "GMT"

In the pg_settings query what are the source, sourcefile, sourceline 
fields set to?


-- 
Adrian Klaver
adrian.klaver@aklaver.com