Hi all, According to the documentation https://www.sqlite.org/lang_corefunc.html SQLite does not provide some basic math functions such as floor and ceil. They are pretty handy additions for "round" function that is present.
For me as developer it would be great to have them in the core. I'm almost confident it will take only a small fraction of time that it took to implement "round" function. Maybe floor and ceil are not part of SQL-92 that AFAIK you try to follow -- but these functions are so common that you should still consider it. P.S. I'm aware of workaround for floor (only for positive numbers -- floor(N) == round(N - 0.5)) but it is only a workaround. -- Truly yours, Artem Skoretskiy
