Received: from web6302.mail.yahoo.com (web6302.mail.yahoo.com [128.11.22.139]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4GDYwA79780 for ; Wed, 16 May 2001 09:34:58 -0400 (EDT) (envelope-from srirao_us@yahoo.com) Message-ID: <20010516133454.428.qmail@web6302.mail.yahoo.com> Received: from [143.209.7.248] by web6302.mail.yahoo.com; Wed, 16 May 2001 06:34:54 PDT Date: Wed, 16 May 2001 06:34:54 -0700 (PDT) From: Srikanth Rao Subject: Restricting the number of decimal digits To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200105/160 X-Sequence-Number: 2977 I have a query that calculates the average of difference between timestamps. I want the output to be upto 1 decimal point. How do I do it? __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/