Re: Time difference without intervals

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: Time difference without intervals
Дата
Msg-id 20021111051745.GG23100@cc.usu.edu
обсуждение исходный текст
Ответ на Re: Time difference without intervals  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Time difference without intervals  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote:
> Roberto Mello <rmello@cc.usu.edu> writes:
> > Is there any way to make a timestamp difference operation not return an
> > interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> > or whatnot.
> 
> I think your complaint is not that you get an interval, but that you
> want it displayed differently.  See to_char() ...

It was not a complaint in any way. I apologize if I came across like that.
It was an honest question.

Thanks for the replies.

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
"Apple" (c) Copyright 1767, Sir Isaac Newton.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Parent table has not oid?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Time difference without intervals