Re: Get days between two dates?

From: "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
To: <emilu(at)encs(dot)concordia(dot)ca>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Get days between two dates?
Date: 2011-01-31 16:33:58
Message-ID: 4CEBB9E1DD3F4E7FAB832985202E4986@marktestcr.marktest.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Doesn't the SELECT you indicated do what you need?

Best,
Oliveiros

----- Original Message -----
From: "Emi Lu" <emilu(at)encs(dot)concordia(dot)ca>
To: <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, January 31, 2011 3:50 PM
Subject: [SQL] Get days between two dates?

> Good morning,
>
> Is there an existing method to get days between two dates?
>
> For example,
>
> select '2010-01-01'::date - '1999-10-12'::date
>
> Returns how many days.
>
> Thank you,
>
> --
> Lu Ying
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2011-01-31 16:36:45 Re: Get days between two dates?
Previous Message Tovo J. RABEMANANTSOA 2011-01-31 16:29:46 Re: Get days between two dates?