Re: Intervals and ISO 8601 duration

On Fri, Jan 13, 2023 at 3:44 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> If I am following what you want is to_char(<interval>,'HH24:MM:SS') to
> be equal, correct?
>

Not really. My original question was:

[since intervals are stored internally as months, days and microseconds...]

> 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?*

And again, I don't want to make anything equal, I'm looking for ways to get
info about the non-identicalness.

I think we've established these two intervals are equal but not identical:

- '1 day 2 hours'::interval
- '26 hours'::interval2

Given that, my questions:

1. Is the internal representation in months, days and microseconds
different for these two intervals?
2. (If no, what else is it that makes them non-identical?)
3. Is there a way to access the internal representation?

And thanks to all of you who have responded!

Cheers,
Ken

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.