Re: fomatting an interval

Forest Wilkinson <lyris-pg@tibit.com>

From: lyris-pg@tibit.com
To: greg@turnstep.com
Cc: pgsql-general@postgresql.org
Date: 2003-05-23T01:07:55Z
Lists: pgsql-hackers
>> Okay, so extract() doesn't fit the bill either.  How do I get the
>> difference between two timestamps in terms of days, expressed as an
>> integer?  Moreover, how do I get any interval expressed in those
>> terms?
>
>select round((extract(epoch from finish) - extract(epoch from start))/(60*60*24)) 
>  from timetable;

How would the following differ from the query above?

select round(extract(epoch from (finish - start))/(60*60*24)) from
timetable;