X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E50D0D76A1 for ; Wed, 7 Sep 2005 02:05:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03373-01 for ; Wed, 7 Sep 2005 05:05:07 +0000 (GMT) Received: from web33402.mail.mud.yahoo.com (web33402.mail.mud.yahoo.com [68.142.206.134]) by svr1.postgresql.org (Postfix) with SMTP id BFD21D7324 for ; Wed, 7 Sep 2005 02:05:07 -0300 (ADT) Received: (qmail 55143 invoked by uid 60001); 7 Sep 2005 05:05:06 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=KMYKpbn14KNe8DUBmGRDZNd7DtkyQDeBIZ/3tNz7inoF90/ctXIpp4RtRwXlMnQWVA4YXXd5rprbb1pAbMBWdiOp/9KWP5bBo3jCgMI0VO4yHde6sn5cegy9as5qGoUXgoaE3P4D1JEIChnNXIF4mOsV5E944U+At8G0EEFVcrE= ; Message-ID: <20050907050506.55141.qmail@web33402.mail.mud.yahoo.com> Received: from [222.124.236.171] by web33402.mail.mud.yahoo.com via HTTP; Tue, 06 Sep 2005 22:05:06 PDT Date: Tue, 6 Sep 2005 22:05:06 -0700 (PDT) From: Louise Catherine Subject: AGE function To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.418 required=5 tests=[AWL=0.633, DNS_FROM_RFC_ABUSE=0.374, FROM_HAS_MIXED_NUMS=0.298, FROM_HAS_MIXED_NUMS3=1.113] X-Spam-Level: ** X-Archive-Number: 200509/67 X-Sequence-Number: 22614 When I execute this statement : select AGE(TO_DATE('20041101','yyyymmdd'), TO_DATE('19991201','yyyymmdd')) at postgre 7.3.3, the result : age --------------------- 4 years 11 mons 1 day at postgre 8.0.3, the result : age --------------- 4 years 11 mons My question : 1. How does postgre 7.3.3 calculate AGE function? 2. Why the result produced by postgre 7.3.3 is different from postgre 8.0.3 ? Thanks, Louise ______________________________________________________ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/