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.

John Woo · Accepted Answer · 2013-02-08T13:50:45.793

45

use CURRENT_TIMESTAMP

select * from tableName where date_column > CURRENT_TIMESTAMP()

edited Feb 08 '13 at 13:50

answered Feb 08 '13 at 13:35

John Woo

In h2 my select now() doesn't work but in update tbl set col = now() it works. How does this fit together? Also they list now() as alternative to current_timestamp on http://www.h2database.com/html/functions.html#current_timestamp – tObi May 19 '17 at 16:10
@john-woo what if date_column is of type date, not timestamp? I'm getting `ORA-30088: datetime/interval precision is out of range` in Oracle for `CURRENT_TIMESTAMP() - date_column` – mdziob Dec 09 '19 at 20:56

score 16 · Answer 2 · answered Feb 08 '13 at 13:41

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

2 Answers2