How to use current date in H2 database SQL query

sql h2
Pavel Vyazankin picture Pavel Vyazankin · Feb 8, 2013 · Viewed 40.5k times · Source

I need something like 

select * from tableName where date_column > now()

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

Answer

John Woo picture John Woo · Feb 8, 2013

use CURRENT_TIMESTAMP

select * from tableName where date_column > CURRENT_TIMESTAMP()

Related questions

Can I have H2 autocreate a schema in an in-memory database?

(I've already seen the H2 database In memory - Init schema via Spring/Hibernate question; it is not applicable here.) I'd like to know if there's a setting in H2 that will allow me to auto-create a schema upon connecting …

Read More
How to find rows in one table that have no corresponding row in another table

I have a 1:1 relationship between two tables. I want to find all the rows in table A that don't have a corresponding row in table B. I use this query: SELECT id FROM tableA WHERE id NOT IN (SELECT id …

Read More
insert a BLOB via a sql script?

I have an H2 database (http://www.h2database.com) and I'd like to insert a file into a BLOB field via a plain simple sql script (to populate a test database for instance). I know how to do that …

Read More