Re: Is there a way to get just the number of seconds between two timestamps?

Поиск
Список
Период
Сортировка
От Michael Lush
Тема Re: Is there a way to get just the number of seconds between two timestamps?
Дата
Msg-id Pine.LNX.4.64.0904081632560.6094@pigeon.ebi.ac.uk
обсуждение исходный текст
Ответ на Is there a way to get just the number of seconds between two timestamps?  (A B <gentosaker@gmail.com>)
Ответы Re: Is there a way to get just the number of seconds between two timestamps?  (A B <gentosaker@gmail.com>)
Список pgsql-novice

On Wed, 8 Apr 2009, A B wrote:
> I want to just get the number of seconds and not have to use extract
> for seconds, minutes, hours, days, months, years, etc.
> Is that possible?

I suppose you could write your own procedure and get a nice new round
thing (if your lucky,  you could reinvent the square wheel:-)

What is wrong with EXTRACT?

--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD            Tel:44-1223 492626
Bioinformatician
HUGO Gene Nomenclature Committee    Email: hgnc@genenames.org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Is there a way to get just the number of seconds between two timestamps?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: scripts for the tutorial