Floor and Ceil can be dynamically loaded. Check last entry here: http://www.sqlite.org/contrib
Today, Artem Skoretskiy wrote: > > 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 > >
