Re: formatting numbers in sap business one query manager

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.

There is an system-wide option to set the number of decimals in the 
queries, but I don't want it as global, just for a few of them


-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........