How to use current date in H2 database SQL query How to use current date in H2 database SQL query sql sql

How to use current date in H2 database SQL query


use CURRENT_TIMESTAMP

select * from tableName where date_column > CURRENT_TIMESTAMP()


IF you want to compare with present date only then use

select * from tableName where date_column > CURRENT_DATE()

IF you want to compare with present date and time also

select * from tableName where date_column > CURRENT_TIMESTAMP