Re: Difference between two times as a numeric value in a stored procedure. [Scanned]

Поиск
Список
Период
Сортировка
От Stijn Vanroye
Тема Re: Difference between two times as a numeric value in a stored procedure. [Scanned]
Дата
Msg-id 736CEAA26E7E3F48943458F760E7A326010CE4@fs1010.farcourier.com
обсуждение исходный текст
Список pgsql-sql
> "Stijn Vanroye" <s.vanroye@Farcourier.com> writes:
> > I can't seem to find a way to substract two time values (or
> > timestamp values) and get a numeric/float value. I always get the
> > INTERVAL datatype.
>
> extract(epoch from interval) may help.
>
>             regards, tom lane
Indeed. I think I should kick myself for missing that, I have read that section af the manual four times or so, and
missedit over and over again :) 

Thanks for the help.

Regards,

Stijn Vanroye.


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

Предыдущее
От: hook
Дата:
Сообщение: trigger data
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Difference between two times as a numeric value in a stored procedure.