MIME-Version: 1.0
References: <CAKna9VY+_b3Cf=BEopo9Z6XcEPsaXSsUUaLJ48YMSMbqT+cSug@mail.gmail.com>
 <fbb258ef-f021-4048-8128-3f3c39491696@aklaver.com>
In-Reply-To: <fbb258ef-f021-4048-8128-3f3c39491696@aklaver.com>
From: Lok P <loknath.73@gmail.com>
Date: Tue, 9 Apr 2024 21:46:35 +0530
Message-ID: <CAKna9VbDkD8FAkeF4jGXCvG7VA9j9FqyjKj9-f0UAj5m=8GZVw@mail.gmail.com>
Subject: Re: Issue with date/timezone conversion function
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a20caa0615ac3fbc"
Archived-At: <https://www.postgresql.org/message-id/CAKna9VbDkD8FAkeF4jGXCvG7VA9j9FqyjKj9-f0UAj5m%3D8GZVw%40mail.gmail.com>
Precedence: bulk

--000000000000a20caa0615ac3fbc
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Apr 9, 2024 at 9:26=E2=80=AFPM Adrian Klaver <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"

--000000000000a20caa0615ac3fbc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"gmail_quote"><div=
 dir=3D"ltr" class=3D"gmail_attr">On Tue, Apr 9, 2024 at 9:26=E2=80=AFPM Ad=
rian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@=
aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex">On 4/9/24 08:43, Lok P wrote:<br>
&gt; Hi All,<br>
&gt; It&#39;s version 15.4 of postgresql database. Every &quot;date/time&qu=
ot; data type <br>
&gt; attribute gets stored in the database in UTC timezone only. One of the=
 <br>
&gt; support persons local timezone is &quot;asia/kolkata&quot; and =C2=A0t=
hat support <br>
&gt; person needs to fetch the count of transactions from a table- <br>
&gt; transaction_tab and share it with another person/customer who is in th=
e <br>
&gt; EST timezone, so basically the transaction has to be shown or displaye=
d <br>
&gt; the EST timezone.<br>
<br>
What is the datatype for the create_timestamp?<br>
<br>
What does SHOW timezone; return on the server?<br>
<br><br></blockquote><div><br></div><div>Thank you for the quick response.<=
/div><div><br></div><div>The column data type for &quot;create_timestamp&qu=
ot; is &quot;timestamptz&#39;.=C2=A0</div><div>Show timezone from the suppo=
rt users client machine UI showing=C2=A0 &quot;Asia/Calcutta&quot;.=C2=A0</=
div><div>Not having access to run &quot;Show timezone&quot; on the server c=
urrently, I will try to get it.</div><div>output=C2=A0from pg_setting showi=
ng setting as &quot;Asia/Calcutta&#39;, reset_val as &quot;Asia/Calcutta&qu=
ot;, boot_val as &quot;GMT&quot;</div></div></div>

--000000000000a20caa0615ac3fbc--