Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f66Jlla52218
	for <pgsql-general@postgresql.org>; Fri, 6 Jul 2001 15:47:47 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f66JlgJ18267;
	Fri, 6 Jul 2001 15:47:43 -0400 (EDT)
To: "Mihai Gheorghiu" <tanethq@earthlink.net>
cc: pgsql-general@postgresql.org
Subject: Re: Number of days 
In-reply-to: <000501c1064c$2829e540$6e646464@New6.Travel> 
References: <000501c1064c$2829e540$6e646464@New6.Travel>
Comments: In-reply-to "Mihai Gheorghiu" <tanethq@earthlink.net>
	message dated "Fri, 06 Jul 2001 14:47:39 -0400"
Date: Fri, 06 Jul 2001 15:47:42 -0400
Message-ID: <18264.994448862@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200107/189
X-Sequence-Number: 12110

"Mihai Gheorghiu" <tanethq@earthlink.net> writes:
> Is there a function that returns the number of days between two dates?

Subtraction.

regression=# select '27 Feb 2001'::date - '5 Jan 2001'::date;
 ?column?
----------
       53
(1 row)

			regards, tom lane