'1 years'::interval to months?

Поиск
Список
Период
Сортировка
От Jon Lapham
Тема '1 years'::interval to months?
Дата
Msg-id 3BFA486C.804@extracta.com.br
обсуждение исходный текст
Список pgsql-general
I have a column defined as type 'INTERVAL'.  It always contains values
with an integral number of months.  For example:

orca_v0_1=# select duration from budget;
    duration
---------------
  1 year
  7 mons
  1 year 5 mons
(3 rows)

Is there a way to query this column such that is only return the
integral number of months?  In the example above, I would like to see
12, 7, 17 returned.

I've tried using 'extract', but the resulting query is rather... shall
we say, inelegent:

orca_v0_1=# select extract(YEARS FROM duration)*12 + extract(MONTHS FROM
duration) from budget;
  ?column?
----------
        12
         7
        17
(3 rows)

PS: Finally, just out of curiousity, is it possible to return the
"fractional" number of months for the situation that an interval is '4
months 2 days'::INTERVAL ?

--

-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
  Jon Lapham
  Extracta Moléculas Naturais, Rio de Janeiro, Brasil
  email: lapham@extracta.com.br      web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------


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

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: email time warps
Следующее
От: Antonio Sergio de Mello e Souza
Дата:
Сообщение: Re: print out custom functions