Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 49CFD477219 for ; Thu, 27 Jun 2002 10:22:56 -0400 (EDT) Mailbox-Line: From VGoodman@aih.co.uk Thu Jun 27 10:22:56 2002 Received: from mailhost.aih.co.uk (unknown [212.161.68.211]) by postgresql.org (Postfix) with ESMTP id 94B3947710B for ; Thu, 27 Jun 2002 09:21:33 -0400 (EDT) Received: (qmail 13669 invoked from network); 27 Jun 2002 13:21:37 -0000 Received: from unknown (HELO vgoodman) ([10.2.1.55]) (envelope-sender ) by mailhost.aih.co.uk (qmail-ldap-1.03) with SMTP for ; 27 Jun 2002 13:21:37 -0000 From: "Valerie Goodman" To: Subject: Subtraction of Dates Date: Thu, 27 Jun 2002 14:21:36 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.30 X-Spam-Level: X-Archive-Number: 200206/388 X-Sequence-Number: 8353 When I want an integer for a number of days between two dates, direct subtraction of two dates returns an integer. However, age function returns an interval. Which is the correct method to use and if age is the correct method, how do I convert that to the number of days?