Re: Retrieving current date - Mailing list pgsql-general

From sivapostgres@yahoo.com
Subject Re: Retrieving current date
Date
Msg-id 411969169.208250.1750314188916@mail.yahoo.com
Whole thread Raw
Responses Re: Retrieving current date
Re: Retrieving current date
List 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 by date:

Previous
From: Al Grant
Date:
Subject: Re: Postgres DB design Question (High Level)
Next
From: "David G. Johnston"
Date:
Subject: Re: Retrieving current date