Re: function to find difference between in days between two dates - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: function to find difference between in days between two dates
Date
Msg-id 162867790706140039j569676a3na70918a65e542f58@mail.gmail.com
Whole thread Raw
In response to Re: function to find difference between in days between two dates  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
2007/6/14, A. Kretschmer <andreas.kretschmer@schollglas.com>:
> am  Thu, dem 14.06.2007, um 11:56:15 +0530 mailte Ashish Karalkar folgendes:
> > Hello all,
> >
> > Is there any function to find  differences in days between two dates?
>
> Yes, age().
>
>

there is difference

date - date --> integer
age(date::timestamp, date::timestamp) --> interval

regards

Pavel


pgsql-sql by date:

Previous
From: "Manso Gomez, Ramon"
Date:
Subject: Re: setof or array as input parameter to postgresql 8.2 functions
Next
From: "Salman Tahir"
Date:
Subject: Organization of tables