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?
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com