Re: Intervals and ISO 8601 duration - Mailing list pgsql-general

From Ken Tanzer
Subject Re: Intervals and ISO 8601 duration
Date
Msg-id CAD3a31XW8iqrZ+uB7if+YUgRjk_=9YQOJRJVBc5__yGRsgypQA@mail.gmail.com
Whole thread Raw
In response to Re: Intervals and ISO 8601 duration  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Intervals and ISO 8601 duration  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, Jan 12, 2023 at 7:08 AM Tom Lane <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.")

Cheers,
Ken


--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Directly embedding a psql SET variable inside another string?
Next
From: Adrian Klaver
Date:
Subject: Re: Intervals and ISO 8601 duration