Re: BUG #1107: Missing feature: interval <-> numeric quantity conversion - Mailing list pgsql-bugs

From Francisco Olarte Sanz
Subject Re: BUG #1107: Missing feature: interval <-> numeric quantity conversion
Date
Msg-id 200403181802.47159.folarte@peoplecall.com
Whole thread Raw
In response to BUG #1107: Missing feature: interval <-> numeric quantity conversion  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Hi:
....
> Having two timestamps it is common need to know how many
> seconds/minutes/hours/days/etc. passed from one to the other. However there
> is no easy way to do this task.

> The basic idea is subtracting the two timestamps. However it gives a data
> type called "interval". The thing I would like to have is a function that
> takes the "interval" and outputs it's length. Currently when I want a
> program to know how long an interval is I must let it parse the interval
> textual representation (which may be subject to change) to obtain what I
> want.

    I do this a lot, just try 'extract(epoch from the_interval)' ( actually in my
code i use things like 'extract(epoch from age(disconnect_time,
connect_time))' where *_time are of type 'timestamp with time zone' and works
like a charm, even across time zone changes.

Francisco Olarte..

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1109: Testing again
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1110: psql -h localhost consults the nameservice