Received: from hotmail.com (oe25.law11.hotmail.com [64.4.16.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f993nvn78413 for ; Mon, 8 Oct 2001 23:49:58 -0400 (EDT) (envelope-from lattim@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 8 Oct 2001 20:49:50 -0700 X-Originating-IP: [210.18.24.152] Reply-To: "Saurabh Mittal" From: "Saurabh Mittal" To: Subject: ROUND function ?? Date: Tue, 9 Oct 2001 09:15:42 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C150A2.F89CBC70" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Message-ID: X-OriginalArrivalTime: 09 Oct 2001 03:49:50.0221 (UTC) FILETIME=[724E3BD0:01C15075] X-Archive-Number: 200110/127 X-Sequence-Number: 5082 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C150A2.F89CBC70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 select ROUND(0.5) ; returns 0 select ROUND(1.5) ; returns 2; select ROUND(2.5) ; returns 2; select ROUND(3.5) ; returns 4;....so on .=20 I'm sure you would have figured out what's happening !!! Why ?? How do I get to approximate any number x.5 as x+1 ?? Saurabh =20 ------=_NextPart_000_0007_01C150A2.F89CBC70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
select ROUND(0.5) ; returns 0
select ROUND(1.5) ; returns 2;
select ROUND(2.5) ; returns 2;
select ROUND(3.5) ; returns 4;....so on .= =20
I'm sure you would have figured out what's= =20 happening !!! Why ??
How do I get to approximate any = number=20 x.5 as x+1 ??
 
Saurabh
 
------=_NextPart_000_0007_01C150A2.F89CBC70--