Re: Get days between two dates?

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Get days between two dates?
Date: 2011-01-31 16:39:27
Message-ID: 20110131163927.GF24931@aart.is.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Jan 31, 2011 at 10:50:43AM -0500, Emi Lu wrote:
> 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
>

Didn't you just answer your own question?

Cheers,
Ken

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2011-01-31 16:39:32 Re: how to get row number in select query
Previous Message Emi Lu 2011-01-31 16:36:45 Re: Get days between two dates?