Re: Retrieving current date

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Retrieving current date
Дата
Msg-id CANzqJaCUjceXYCB2F91tSADq6c8rXuJq-MSCAXWuGuJf61_oBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Retrieving current date  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Jun 19, 2025 at 2:23 AM sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:
Hello,
May be a very basic question.  We all here are new to Linux / PostgreSQL

Ubuntu Server 22.04
PostgreSQL 15
PgAdmin4 6.16

When I run the following query in pg_admin

Select today_now 
From   (Select localtimestamp(0) as today_now) a;

I get UTC time and not the IST time, which I expect.

How to change the setting(s), if any, to retrieve the current date and time in IST?

In addition, see what time zone the Linux server is at:

$ timedatectl | grep zone
                Time zone: America/New_York (EDT, -0400)

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

В списке pgsql-general по дате отправления: