Get days between two dates?

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Get days between two dates?
Date: 2011-01-31 15:50:43
Message-ID: 4D46DA53.9050402@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tovo J. RABEMANANTSOA 2011-01-31 16:29:46 Re: Get days between two dates?
Previous Message Viktor Bojović 2011-01-31 15:37:16 Re: aggregation of setof