Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3EA221337B92 for ; Mon, 31 Jan 2011 12:44:11 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 25989-03 for ; Mon, 31 Jan 2011 16:44:04 +0000 (UTC) X-Greylist: delayed 00:14:15.331114 by SQLgrey-1.7.6 Received: from ssueic16.bordeaux.inra.fr (ssueic16.bordeaux.inra.fr [147.100.111.218]) by mail.postgresql.org (Postfix) with ESMTP id A75B91337B8C for ; Mon, 31 Jan 2011 12:44:03 -0400 (AST) Received: from [147.100.98.90] ([147.100.98.90]) (authenticated bits=0) by ssueic16.bordeaux.inra.fr (/8.14.4) with ESMTP id p0VGTkA7004383 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Mon, 31 Jan 2011 17:29:46 +0100 (CET) Message-ID: <4D46E37A.4080802@bordeaux.inra.fr> Date: Mon, 31 Jan 2011 17:29:46 +0100 From: "Tovo J. RABEMANANTSOA" User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101230 Lightning/1.0b2 Lanikai/3.1.7 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Get days between two dates? References: <4D46DA53.9050402@encs.concordia.ca> In-Reply-To: <4D46DA53.9050402@encs.concordia.ca> X-Enigmail-Version: 1.1.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Miltered: at ssueic16 with ID 4D46E37A.001 by Joe's j-chkmail (http : // j-chkmail dot ensmp dot fr)! X-j-chkmail-Enveloppe: 4D46E37A.001/147.100.98.90/[147.100.98.90]/[147.100.98.90]/ X-j-chkmail-Score: MSGID : 4D46E37A.001 on ssueic16.bordeaux.inra.fr : j-chkmail score : . : R=. U=. O=. B=0.000 -> S=0.000 X-j-chkmail-Status: Ham X-Virus-Scanned: clamav-milter 0.95.2 at ssueic16 X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/129 X-Sequence-Number: 35076 On 01/31/2011 04:50 PM, 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 > Hi ! Yes there is : date '2001-10-01' - date '2001-09-28' returns integer '3' (days) as said here : http://www.postgresql.org/docs/8.4/interactive/functions-datetime.html -- Tovo J. RABEMANANTSOA INRA - UR1263 EPHYSE 71, Av. Edouard Bourlaux F-33140 Villenave d'Ornon - France Téléphone : +33 5 57 12 24 09