[zazaulola]

For positive numbers, both the FLOOR() and TRUNC() functions return the same values

[benatkin]

And for negative numbers it's CEIL()!

And in SQL Server, ROUND() with a nonzero number for the third parameter for truncate, and CELING() for ceiling.