Re: DateDiff in PostgreSQL

Поиск
Список
Период
Сортировка
Искать

Re: DateDiff in PostgreSQL

От:
"George A.J" <jinujosein@yahoo.com>
Дата:


Yasir Malik <ymalik@heineken.cs.stevens-tech.edu> wrote:

>You can use the age() function to find the difference between dates, and
>use the extract() function to get the years, months, days, etc.
>Yasir

this will not work because age('25/12/1975','30/01/1986')
wil return '10 year 1 month 5 days'

extract only returns years -10, moths-1, days-5.

this is not i want.Actual month  difference between the dates are 121 months.

jinu jose

 


Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

Re: DateDiff in PostgreSQL

От:
Yasir Malik <ymalik@cs.stevens-tech.edu>
Дата:
FAQ