Re: fomatting an interval - Mailing list pgsql-general

From lyris-pg@tibit.com
Subject Re: fomatting an interval
Date
Msg-id 8rsqcv87sac2c1hh6nqkg0dj4cminlbo7r@4ax.com
Whole thread Raw
In response to Re: fomatting an interval (resend)  (greg@turnstep.com)
Responses Re: fomatting an interval (resend)  (lyris-pg@tibit.com)
How to enumerate foreign key constraints after migrating from 7.1.3?  (Forest Wilkinson <lyris-pg@tibit.com>)
List pgsql-general
>> 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;


pgsql-general by date:

Previous
From: Forest Wilkinson
Date:
Subject: Empty queries guaranteed to work?
Next
From: Bruno Wolff III
Date:
Subject: Re: tablemeta-data