Date: Thu, 19 Jun 2025 06:23:08 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Message-ID: <411969169.208250.1750314188916@mail.yahoo.com>
Subject: Re:  Retrieving current date
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_208249_1851120009.1750314188915"
References: <411969169.208250.1750314188916.ref@mail.yahoo.com>
Content-Length: 2096
Archived-At: <https://www.postgresql.org/message-id/411969169.208250.1750314188916%40mail.yahoo.com>
Precedence: bulk

------=_Part_208249_1851120009.1750314188915
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello,May be a very basic question.=C2=A0 We all here are new to Linux / Po=
stgreSQL
Ubuntu Server 22.04PostgreSQL 15PgAdmin4 6.16
When I run the following query in pg_admin
Select today_now=C2=A0From=C2=A0 =C2=A0(Select localtimestamp(0) as today_n=
ow) 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

------=_Part_208249_1851120009.1750314188915
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"yahoo-style-wrap" style=3D"font-fami=
ly:times new roman, new york, times, serif;font-size:16px;"><div dir=3D"ltr=
" data-setdir=3D"false">Hello,</div><div dir=3D"ltr" data-setdir=3D"false">=
May be a very basic question.&nbsp; We all here are new to Linux / PostgreS=
QL</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" d=
ata-setdir=3D"false">Ubuntu Server 22.04</div><div dir=3D"ltr" data-setdir=
=3D"false">PostgreSQL 15</div><div dir=3D"ltr" data-setdir=3D"false">PgAdmi=
n4 6.16</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"l=
tr" data-setdir=3D"false">When I run the following query in pg_admin</div><=
div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdi=
r=3D"false"><div><div>Select today_now&nbsp;</div><div>From&nbsp; &nbsp;(Se=
lect localtimestamp(0) as today_now) a;</div><div><br></div></div>I get UTC=
 time and not the IST time, which I expect.</div><div dir=3D"ltr" data-setd=
ir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">How to change=
 the setting(s), if any, to retrieve the current date and time in IST?</div=
><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-set=
dir=3D"false">Happiness Always<br>BKR Sivaprakash</div><div dir=3D"ltr" dat=
a-setdir=3D"false"><br></div></div></body></html>
------=_Part_208249_1851120009.1750314188915--