public inbox for [email protected]
help / color / mirror / Atom feedRe: Issue with date/timezone conversion function
2+ messages / 2 participants
[nested] [flat]
* Re: Issue with date/timezone conversion function
@ 2024-04-09 16:16 Lok P <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Lok P @ 2024-04-09 16:16 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: pgsql-general <[email protected]>
On Tue, Apr 9, 2024 at 9:26 PM Adrian Klaver <[email protected]>
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"
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Issue with date/timezone conversion function
@ 2024-04-09 16:58 Adrian Klaver <[email protected]>
parent: Lok P <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Adrian Klaver @ 2024-04-09 16:58 UTC (permalink / raw)
To: Lok P <[email protected]>; +Cc: pgsql-general <[email protected]>
On 4/9/24 9:16 AM, Lok P wrote:
>
> On Tue, Apr 9, 2024 at 9:26 PM Adrian Klaver <[email protected]
> <mailto:[email protected]>> 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
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-04-09 16:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-04-09 16:16 Re: Issue with date/timezone conversion function Lok P <[email protected]>
2024-04-09 16:58 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox