On Fri, Jan 13, 2023 at 3:41 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 1/13/23 14:17, Ken Tanzer wrote: > > On Thu, Jan 12, 2023 at 7:08 AM Tom Lane <t...@sss.pgh.pa.us > > <mailto:t...@sss.pgh.pa.us>> wrote: > > > > What Postgres actually stores for an interval is three fields: > > months, days, and microseconds. > > > > > > Is there a way to view/extract this raw data for any given interval? > > > > (I'm asking because of an issue that came up about intervals that were > > "equal but not identical.") > > 1) Can you provide an example? > > 2) I don't know how to reverse an output interval to it's input value. > > That wasn't the ask though: select interval '2 year 36 hours 15.123456789 seconds'; yields: 2 years 36:00:15.123457 But if what is stored is only months, days, and microseconds what is being requested is to produce: 24 months 1.5 days 15123457 microseconds (or whatever the values stored in those three positions is...) David J.
