| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com> |
| Cc: | "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:34:40 |
| Message-ID: | CAKFQuwYe4cw1P9NHfq+=rPFkuTCspb=8fUOkFUoB1FC-dyBVeQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday, June 18, 2025, sivapostgres(at)yahoo(dot)com <sivapostgres(at)yahoo(dot)com>
wrote:
>
>
> How to change the setting(s), if any, to retrieve the current date and
> time in IST?
>
https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-TIMEZONES
Not totally sure if that will or won’t impact how pgAdmin behaves but it is
how you tell the server where you are. Strongly advise using the full
formal name and not an abbreviation or offset.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominique Devienne | 2025-06-19 13:09:03 | Extension disappearing act |
| Previous Message | sivapostgres@yahoo.com | 2025-06-19 06:23:08 | Re: Retrieving current date |