Re: fomatting an interval
| От | lyris-pg@tibit.com |
|---|---|
| Тема | Re: fomatting an interval |
| Дата | |
| Msg-id | 8rsqcv87sac2c1hh6nqkg0dj4cminlbo7r@4ax.com обсуждение исходный текст |
| Ответ на | Re: fomatting an interval (resend) (greg@turnstep.com) |
| Ответы |
Re: fomatting an interval (resend)
How to enumerate foreign key constraints after migrating from 7.1.3? |
| Список | 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 по дате отправления: