Horton

Re: PostgreSQL 17 Release Management Team & Feature Freeze

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>, Heikki Linnakangas <hlinnaka@iki.fi>, Robert Haas <robertmhaas@gmail.com>
Date: 2024-04-07T22:50:41Z
Lists: pgsql-hackers 
On Thu, Apr 04, 2024 at 03:10:27PM +1300, David Rowley wrote:
> Someone asked me about this, so thought it might be useful to post here.

I've received the same question.

> To express this as UTC, It's:
> 
> postgres=# select '2024-04-08 00:00-12:00' at time zone 'UTC';
>       timezone
> ---------------------
>  2024-04-08 12:00:00
> 
> Or, time remaining, relative to now:
> 
> select '2024-04-08 00:00-12:00' - now();

And, as of the moment of typing this email, I get:
=# select '2024-04-08 00:00-12:00' - now() as time_remaining;
 time_remaining
-----------------
 13:10:35.688134
(1 row)

So there is just a bit more than half a day remaining before the
feature freeze is in effect.
--
Michael