public inbox for [email protected]  

help / color / mirror / Atom feed

From: Frank Heikens <[email protected]>
To: Gary Clarke <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Interval unit format bug
Date: Thu, 30 Apr 2026 14:03:14 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

There is something about the presentation in the documentation: https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-OUTPUT

What would you expect, and how would this be different from the documented output?


Best regards,

Frank


Ps. Drivers like the JDBC driver can also change the format


On Apr 29, 2026, at 5:00 AM, Gary Clarke <[email protected]> wrote:

Hello

Applies to all versions and operating systems

Even if I set to verbose, Postgres outputs a very strange abbreviation for interval unit months that nobody else uses or would expect.

<image001.png>


Best Regards

Gary



<image002.jpg>
Gary Clarke
Onedb CEO
[email protected]<mailto:[email protected]>
+351 9688 20662
+44 746 223 4269
www.onedb.online<http://www.onedb.online/;

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Interval unit format bug
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox