Re: [SQL] function to find difference between in days between two dates

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>, "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] function to find difference between in days between two dates
Date: 2007-06-14 11:54:09
Message-ID: 162867790706140454q5e08cff6n22ed5d58748949ed@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

2007/6/14, Martijn van Oosterhout <kleptog(at)svana(dot)org>:
> On Thu, Jun 14, 2007 at 09:00:12AM +0200, Pavel Stehule wrote:
> > Hello
> >
> > PostgreSQL hasn't any official function for it. If you need it, you
> > can write own function
>
> Not true. Anything that is done by an operator as actually done by a
> function. So the function exists:
>
> # \df date_mi
> List of functions

I know about it, but it's undocumented

Pavel

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-06-14 12:06:33 Re: pointer to feature comparisons, please
Previous Message Andrus 2007-06-14 11:47:30 Re: how to speed up query

Browse pgsql-sql by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-06-14 12:26:28 Re: [SQL] function to find difference between in days between two dates
Previous Message Salman Tahir 2007-06-14 11:21:06 Organization of tables