[Info-Ingres] ROUNDING numbers in sql procedure

[martin.bowes at ctsu.ox.ac.uk]

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 at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>