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.klaver@xxxxxxxxxxx
