Re: fomatting an interval (resend)

Поиск
Список
Период
Сортировка
От lyris-pg@tibit.com
Тема Re: fomatting an interval (resend)
Дата
Msg-id 7jucdvsvcuefau6lnj5t9mdftu8h07v00f@4ax.com
обсуждение исходный текст
Ответ на Re: fomatting an interval  (lyris-pg@tibit.com)
Ответы Re: fomatting an interval (resend)  (greg@turnstep.com)
Список 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 that differ from the query below?

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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Jay O'Connor"
Дата:
Сообщение: Re: PLPGSQL problem with SELECT INTO
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PLPGSQL problem with SELECT INTO