Received: from web801.mail.yahoo.com (web801.mail.yahoo.com [128.11.23.61]) by hub.org (8.10.1/8.10.1) with SMTP id e8RJ9Hr57998 for ; Wed, 27 Sep 2000 15:09:17 -0400 (EDT) Received: (qmail 27310 invoked by uid 60001); 27 Sep 2000 19:09:16 -0000 Message-ID: <20000927190916.27309.qmail@web801.mail.yahoo.com> Received: from [63.170.255.39] by web801.mail.yahoo.com; Wed, 27 Sep 2000 12:09:16 PDT Date: Wed, 27 Sep 2000 12:09:16 -0700 (PDT) From: Webb Sprague Subject: Getting number of days To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200009/222 Hi All, Does anybody know how to convert an interval into a number of days. Say I have something like '2 years 4 months 4 ago', I need to get the total number of days, something like 800 (ish). Is there a built in function? Thanks W __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/