get start of the day in sql

Question

I used to use trunc(sysdate) to get start of the day and trunc(sysdate + 1) to get end of the day in Oracle.
But for tests we use H2 DB and this doesn't work.

Are there any lovely alternatives to get start of the day?

Answer 1

There is an possibility to add user-defined functions.

Answer 2

Try to use CURRENT_DATE in h2.