Re: formatting numbers in sap business one query manager

On 17/08/2020 14.08, Ammammata wrote:
> Il giorno Mon 17 Aug 2020 01:28:43p, *J.O. Aho* ha inviato su
> comp.databases.mysql il messaggio news:[email protected].
> Vediamo cosa ha scritto:
> 
>> you could try FLOOR(x), this will still be a numeric value
> 
> yes, I gave it a try, but it keeps the decimals
> 
> SQL Server FLOOR() Function
> https://www.w3schools.com/sql/func_sqlserver_floor.asp
> 
> The FLOOR() function returns the largest integer value that is smaller than
> or equal to a number.

Which means you would get the value you looking for, as 11.00000 would 
become 11, this avoids you to change a system wide value while you run 
the query and get the issues it can give.

-- 

  //Aho