Re: Retrieving current date

[sivapostg...@yahoo.com]

Hello,May be a very basic question.  We all here are new to Linux / PostgreSQL
Ubuntu Server 22.04PostgreSQL 15PgAdmin4 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