Re: Retrieving current date

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Retrieving current date
Date: 2025-06-19 06:23:08
Message-ID: 411969169.208250.1750314188916@mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-06-19 06:34:40 Re: Retrieving current date
Previous Message Al Grant 2025-06-19 05:08:37 Re: Postgres DB design Question (High Level)