Re: DateDiff in PostgreSQL - Mailing list pgsql-sql

From George A.J
Subject Re: DateDiff in PostgreSQL
Date
Msg-id 20031107135335.29716.qmail@web14909.mail.yahoo.com
Whole thread Raw
In response to DateDiff in PostgreSQL  ("George A.J" <jinujosein@yahoo.com>)
List pgsql-sql


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

pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: DateDiff in PostgreSQL
Next
From: Rod Taylor
Date:
Subject: Re: DateDiff in PostgreSQL