Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uS8rH-003vbr-8u for pgsql-general@arkaria.postgresql.org; Thu, 19 Jun 2025 06:34:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uS8rF-008SoT-DV for pgsql-general@arkaria.postgresql.org; Thu, 19 Jun 2025 06:34:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uS8rF-008SoC-2v for pgsql-general@lists.postgresql.org; Thu, 19 Jun 2025 06:34:45 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uS8rD-002tZT-1J for pgsql-general@lists.postgresql.org; Thu, 19 Jun 2025 06:34:45 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-72c14138668so115145a34.2 for ; Wed, 18 Jun 2025 23:34:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750314881; x=1750919681; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=IgqhVWUKDQWMU6wMqnV/IYQXy0foOuUzD+bW+LZoGd8=; b=K+WvwmxK8pOuXY6s8s00A3jkmC79Rx00byA8mYKrUmFcUh5OzyvyLiadIAUjqxihL4 EMuaMzIRJoZ24JIJx79luqVLnFj9STy54Ey966MlFEqxrBTZjkf01Hkd2ajZhPKJpCRd uUd39qZLFWll0WWrolfyPeMXSqZD9m+pGix2J1BIAi6Aa1XjQbpPO7+vY7XFDUNwQost 2Z5tZ8NiVwKBUoCCLUt4qCCalmG+cyhZEsG/tJNWt2JSfvq7+LuV/V6Z5pEArBKOV88o 9jnMlvP3IZOOYlvxOCL0LeITzklBq9xZmTqK22sMfGj+IRtXksZJBALNEyVpvZU2E3gT oNpg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750314881; x=1750919681; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=IgqhVWUKDQWMU6wMqnV/IYQXy0foOuUzD+bW+LZoGd8=; b=IczC0PVeIKmK4sL8T1YkCZO8X+w0rskvzeY466VvI4NNNzCd2N3UKZz+f1EunmrGta GR60HaOAdSEEqkUKOGRaglc6dg1OwHF5GKn7lkljaf5JN4zrF1oGUsIn9tdQNv0IDeh9 JOxwJIJBTm3DvCgK/gG6B0DnuvfqK4K7aQmioZxYU9o0qR0r3q0zF5JBWMU7JqLx1K4J tLvQbHGC6YzRV7XV6La23//PzfUlodNZtwO5D+Br6nK/Ie7HgfI06G6z26Iy0xpA+2mb zpvb1R0aJsvGm9X5wqTwQBewZATGsDYmMhnLh6B6jxhN8Olrdrelm3BhutZOWK4fOhUS trMw== X-Gm-Message-State: AOJu0YzyXeFzfHsRwT9jidZXuDdQoYhbIbnqKGeqvaketwq8d3Kg+IJE NP2MGzC264xFTb1eNxQtYp5byPDqpHhuszcaGBEAmYy+E0d1wSMCSWwCHVGfqkJJF2O5wVGPAov 8wnty+JD8dgYSXX8akgc38adMaKUYLmI= X-Gm-Gg: ASbGncujP91IPhQAQ3vxft4vIW6uMEm7TPZuQZjSM9JsvqEZfp+KZ0gjUUPa8mx9r/i U+3eTSIvLScsB4JJhcj3o+Dq6CTfbwk0rJ/qiZ3CG2ycDPe6fhhVOs7U/F+JL0Pj00VDY0oXF+a 3ZPWa93/4PuJNNC2HrcvAS3pb2c8Z+TRqMypK0LMoGtK1moXgzp+gOeT3RRycPPeYMNHMO9OUSd 04m X-Google-Smtp-Source: AGHT+IE/lOM8jRS9VRoiOqN33LFn5TBUOcCbJL6wFM2N2gu785BWYwBzpoIDPi1+AVKJFsCLBWe1d6DVBFz1Pe1fnKw= X-Received: by 2002:a05:6820:c8c:b0:611:50ea:5496 with SMTP id 006d021491bc7-61150ea5620mr840304eaf.3.1750314881532; Wed, 18 Jun 2025 23:34:41 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:28a6:b0:5d1:1254:d2a7 with HTTP; Wed, 18 Jun 2025 23:34:40 -0700 (PDT) In-Reply-To: <411969169.208250.1750314188916@mail.yahoo.com> References: <411969169.208250.1750314188916.ref@mail.yahoo.com> <411969169.208250.1750314188916@mail.yahoo.com> From: "David G. Johnston" Date: Wed, 18 Jun 2025 23:34:40 -0700 X-Gm-Features: AX0GCFshBSNyXTEq60oWhNF4BWchc3jDlsD0Ril8RP_hI3-2aUUBKZFxQYnBw1Y Message-ID: Subject: Re: Retrieving current date To: "sivapostgres@yahoo.com" Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000c249700637e6f0d0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c249700637e6f0d0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, June 18, 2025, sivapostgres@yahoo.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-TIM= EZONES Not totally sure if that will or won=E2=80=99t impact how pgAdmin behaves b= ut 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. --000000000000c249700637e6f0d0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, June 18, 2025, siva= postgres@yahoo.com <sivapo= stgres@yahoo.com> wrote:

How to change the setting(s), if any, t= o retrieve the current date and time in IST?
<= br>

= Not totally sure if that will or won=E2=80=99t impact how pgAdmin behaves b= ut it is how you tell the server where you are.=C2=A0 Strongly advise using= the full formal name and not an abbreviation or offset.

David J.

--000000000000c249700637e6f0d0--