Date: Fri, 20 Jun 2025 11:08:41 +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>, 
	Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <2120898981.577779.1750417721559@mail.yahoo.com>
In-Reply-To: <935dcc5f-0f78-4780-867e-8310b9f0d9fd@aklaver.com>
References: <411969169.208250.1750314188916.ref@mail.yahoo.com> <411969169.208250.1750314188916@mail.yahoo.com> <935dcc5f-0f78-4780-867e-8310b9f0d9fd@aklaver.com>
Subject: Re: Retrieving current date
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_577778_621510787.1750417721558"
Content-Length: 5119
Archived-At: <https://www.postgresql.org/message-id/2120898981.577779.1750417721559%40mail.yahoo.com>
Precedence: bulk

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

 Thanks all,
I just changed the timezone setting in postgresql.conf file.=C2=A0 That res=
olved this issue.

    On Thursday 19 June, 2025 at 07:41:16 pm IST, Adrian Klaver <adrian.kla=
ver@aklaver.com> wrote: =20
=20
 On 6/18/25 23:23, sivapostgres@yahoo.com wrote:
> Hello,
> May be a very basic question.=C2=A0 We all here are new to Linux / Postgr=
eSQL
>=20
> Ubuntu Server 22.04
> PostgreSQL 15
> PgAdmin4 6.16
>=20
> When I run the following query in pg_admin
>=20
> Select today_now
> From=C2=A0 =C2=A0(Select localtimestamp(0) as today_now) a;
>=20
> I get UTC time and not the IST time, which I expect.
>=20
> How to change the setting(s), if any, to retrieve the current date and=20
> time in IST?

For setting see:

https://www.postgresql.org/docs/current/runtime-config-client.html

"TimeZone (string)

=C2=A0 =C2=A0 Sets the time zone for displaying and interpreting time stamp=
s. The=20
built-in default is GMT, but that is typically overridden in=20
postgresql.conf; initdb will install a setting there corresponding to=20
its system environment. See Section 8.5.3 for more information.
"

For a quick fix, maybe?:

select localtimestamp(0) at time zone 'Asia/Kolkata' as today_now;

>=20
> Happiness Always
> BKR Sivaprakash
>=20

--=20
Adrian Klaver
adrian.klaver@aklaver.com


 =20
------=_Part_577778_621510787.1750417721558
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydp2e6ef1b3yahoo-style-wrap" style=
=3D"font-family:times new roman, new york, times, serif;font-size:16px;"><d=
iv></div>
        <div dir=3D"ltr" data-setdir=3D"false">Thanks all,</div><div dir=3D=
"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false=
">I just changed the timezone setting in postgresql.conf file.&nbsp; That r=
esolved this issue.</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><=
div><br></div>
       =20
        </div><div id=3D"yahoo_quoted_0843630346" class=3D"yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Thursday 19 June, 2025 at 07:41:16 pm IST, Adria=
n Klaver &lt;adrian.klaver@aklaver.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div dir=3D"ltr">On 6/18/25 23:23, <a shape=3D"rect" y=
mailto=3D"mailto:sivapostgres@yahoo.com" href=3D"mailto:sivapostgres@yahoo.=
com">sivapostgres@yahoo.com</a> wrote:<br clear=3D"none">&gt; Hello,<br cle=
ar=3D"none">&gt; May be a very basic question.&nbsp; We all here are new to=
 Linux / PostgreSQL<br clear=3D"none">&gt; <br clear=3D"none">&gt; Ubuntu S=
erver 22.04<br clear=3D"none">&gt; PostgreSQL 15<br clear=3D"none">&gt; PgA=
dmin4 6.16<br clear=3D"none">&gt; <br clear=3D"none">&gt; When I run the fo=
llowing query in pg_admin<br clear=3D"none">&gt; <br clear=3D"none">&gt; Se=
lect today_now<br clear=3D"none">&gt; From&nbsp; &nbsp;(Select localtimesta=
mp(0) as today_now) a;<br clear=3D"none">&gt; <br clear=3D"none">&gt; I get=
 UTC time and not the IST time, which I expect.<br clear=3D"none">&gt; <br =
clear=3D"none">&gt; How to change the setting(s), if any, to retrieve the c=
urrent date and <br clear=3D"none">&gt; time in IST?<br clear=3D"none"><br =
clear=3D"none">For setting see:<br clear=3D"none"><br clear=3D"none"><a sha=
pe=3D"rect" href=3D"https://www.postgresql.org/docs/current/runtime-config-=
client.html" target=3D"_blank">https://www.postgresql.org/docs/current/runt=
ime-config-client.html</a><br clear=3D"none"><br clear=3D"none">"TimeZone (=
string)<br clear=3D"none"><br clear=3D"none">&nbsp; &nbsp;  Sets the time z=
one for displaying and interpreting time stamps. The <br clear=3D"none">bui=
lt-in default is GMT, but that is typically overridden in <br clear=3D"none=
">postgresql.conf; initdb will install a setting there corresponding to <br=
 clear=3D"none">its system environment. See Section 8.5.3 for more informat=
ion.<br clear=3D"none">"<br clear=3D"none"><br clear=3D"none">For a quick f=
ix, maybe?:<br clear=3D"none"><br clear=3D"none">select localtimestamp(0) a=
t time zone 'Asia/Kolkata' as today_now;<div class=3D"yqt2242884895" id=3D"=
yqtfd71367"><br clear=3D"none"><br clear=3D"none">&gt; <br clear=3D"none">&=
gt; Happiness Always<br clear=3D"none">&gt; BKR Sivaprakash</div><br clear=
=3D"none">&gt; <br clear=3D"none"><br clear=3D"none">-- <br clear=3D"none">=
Adrian Klaver<br clear=3D"none"><a shape=3D"rect" ymailto=3D"mailto:adrian.=
klaver@aklaver.com" href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver=
@aklaver.com</a><div class=3D"yqt2242884895" id=3D"yqtfd72676"><br clear=3D=
"none"><br clear=3D"none"><br clear=3D"none"><br clear=3D"none"></div></div=
></div>
            </div>
        </div></body></html>
------=_Part_577778_621510787.1750417721558--