Elapsed time between timestamp variables in Function

Поиск

Список

Период

Сортировка

От	Nico Callewaert
Тема	Elapsed time between timestamp variables in Function
Дата	4 февраля 2009 г. 17:59:34
Msg-id	EB846396B3254BAD98E7DB7BDE2AFEF6@etsinformatics.local обсуждение
Ответы	Re: Elapsed time between timestamp variables in Function Re: Elapsed time between timestamp variables in Function
Список	pgsql-general

Дерево обсуждения

Hi !

I saw previous postings about elapsed time between 2 timestamps, using SELECT EXTRACT...

I have similar question, but it's not in a select statement, but between 2 variables in a function.

To keep it simple, I have 2 variables, let's say A and B, both TimeStamp. Now I would like to know the absolute value of elapsed seconds between the 2 timestamps. Has to be absolute value, because can be positive or negative, depends if A > B or A < B.

I tried with age(A, B), but that gives me something like 00:00:01, not really numeric value for number of seconds.

Many thanks in advance !

Nico

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Elapsed time between timestamp variables in Function