3 ms·
For positive numbers, both the FLOOR() and TRUNC() functions return the same values
by zazaulola 2y ago
For positive numbers, both the FLOOR() and TRUNC() functions return the same values
- benatkin 2y agoAnd 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.