Re: Intervals and ISO 8601 duration

On 1/13/23 14:17, Ken Tanzer wrote:
> On Thu, Jan 12, 2023 at 7:08 AM Tom Lane <tgl@sss.pgh.pa.us 
> <mailto:tgl@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.


> 
> Cheers,
> Ken
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com