Re: datediff is there something like it? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: datediff is there something like it?
Date
Msg-id 20050126201319.GA23744@wolff.to
Whole thread Raw
In response to datediff is there something like it?  ("Joel Fradkin" <jfradkin@wazagua.com>)
List pgsql-sql
On Tue, Jan 25, 2005 at 10:11:40 -0500, Joel Fradkin <jfradkin@wazagua.com> wrote:
> Hi all working my way through our views and all is going very well.
> 
> We use datediff in MSSQL a bit and I read about the field1::date -
> field2::date to return the days numerically.
> 
> Is there any way to get months and years besides guessing days / 30 for
> months etc?

The age function will give a difference in years-months in addition to
days-hours-minutes-seconds.
Depending on what you want, it may not do exactly what you want.


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: working with multidimensional arrays in plpgsql
Next
From: Bruno Wolff III
Date:
Subject: Re: same question little different test MSSQL vrs Postgres