How to use current date in H2 database SQL query

Question

I need something like

select * from tableName where date_column > now() 

However, now() doesn't work in H2. Please advise.

Answer 1

use CURRENT_TIMESTAMP

select * from tableName where date_column > CURRENT_TIMESTAMP() 

• CURRENT_TIMESTAMP