Re: Retrieving current date

Поиск
Список
Период
Сортировка
От sivapostgres@yahoo.com
Тема Re: Retrieving current date
Дата
Msg-id 411969169.208250.1750314188916@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Retrieving current date
Re: Retrieving current date
Список pgsql-general
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?

Happiness Always
BKR Sivaprakash

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