Hi Martin,

be careful, you will get undesired results with negative numbers !
How about using the builtin function round() ?

Jürgen




-------- Original Message --------
Subject: Re: [Info-Ingres] ROUNDING numbers in sql procedure
Date: Thu, 02 Aug 2007 10:38:14 +0100
From: martin.bowes@ctsu.ox.ac.uk
To: npiet@gascognelaminates.com
CC: info-ingres@kettleriverconsulting.com



Hi Nathalie

Why not just add 0.5 to the result before the integer conversion occurs?

Marty

> I have procedures in an ingres database
> In these procedures, I do some numbers operations.
> when the result is for example 3644,6 the number is rounded to 3644
> and I would like that it's rounded to 3645. how can i do to round to
> the next number ? is there an function wich do this ? thanks
>
> Nathalie
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com...fo/info-ingres
>


_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres