Re: Intervals and ISO 8601 duration

On 1/13/23 15:57, Adrian Klaver wrote:
> On 1/13/23 15:32, Ken Tanzer wrote:
>> On Fri, Jan 13, 2023 at 3:03 PM Adrian Klaver <adrian.klaver@aklaver.com 
> 
>> Cheers,
>> Ken
>>
>> (*) These are probably bad suggestions, but something like...
>>
>>       EXTRACT ( (RAWHOURS|RAWDAYS|RAWMICROSECONDS) ... ?
>>       Or a function RAWEXTRACT( HOURS|DAYS|MICROSECONDS ) ?
> 
> Close as I can get:
> 
> 
> WITH inters AS (
>      SELECT
>          extract(epoch from '1 day 2 hours'::interval) AS i1,
>          extract(epoch from '26 hours'::interval) AS i2
> )
> SELECT
>      i1,
>      i2,
>      i1=i2 AS "Equal?"
> FROM inters;
> 
>   i1      |      i2      | Equal?
> --------------+--------------+--------
>   93600.000000 | 93600.000000 | t

Or:

WITH inters AS (
     SELECT
         make_interval(secs=>extract(epoch from  '1 day 2 
hours'::interval)) as i1,
         make_interval(secs=>extract(epoch from  '26 hours'::interval)) 
as i2
)
SELECT
     i1,
     i2,
     i1=i2 AS "Equal?"
FROM inters;
     i1    |    i2    | Equal?
----------+----------+--------
  26:00:00 | 26:00:00 | t

> 
>>
>>
>>     --     Adrian Klaver
>>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>>
>>
>>
>> -- 

-- 
Adrian Klaver
adrian.klaver@aklaver.com