For positive numbers, both the FLOOR() and TRUNC() functions return the same val... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		zazaulola 6 months ago \| parent \| context \| favorite \| on: All clocks are 30 seconds late For positive numbers, both the FLOOR() and TRUNC() functions return the same values

benatkin 6 months ago [–]

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.

Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact