Re: Retrieving current date

["sivapostgres@xxxxxxxxx" <sivapostgres@xxxxxxxxx>]

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