Re: is in postgres solution

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: is in postgres solution
Дата
Msg-id 20050516194926.GA31098@wolff.to
обсуждение исходный текст
Ответ на is in postgres solution  (Margus Roo <margusja@101d.ee>)
Список pgsql-general
On Mon, May 16, 2005 at 11:43:09 +0300,
  Margus Roo <margusja@101d.ee> wrote:
> Hello.
> I have 2 variables type timestamp. Example date1 = 2005-01-01 23:00 and
> date2 = 2005-05-04 12:00. I want get something like age(date2,date1) but
> ouput format must by hours::minutes.
>
> Is that bossible?

extract the epoch from the difference in timestamps and that will give
you a time in seconds that you can format as desired with a little
math.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Distinguishing between connections in pg_hba.conf
Следующее
От: Adam Witney
Дата:
Сообщение: Re: Distinguishing between connections in pg_hba.conf