Comparing current date (Java) to a Timestamp in a DB (sql) using Hibernate

Question

I am trying to check if an entry to the DB has occurred today. My Query works when I run it with MySqlWorkbench, but when I use hibernate the query does not seem to work correctly I am always returned true even though the DB does have dates today.

The query is: @Query("SELECT CASE WHEN (count(ent) < 1) then true else false end FROM Entity ent WHERE ent.createdAt >= (?1)") boolean checkIfEnteredToday(Date date);

The date is from the java.sql.Date library.

C Murphy · Accepted Answer · 2019-04-12 11:24:26Z

1

I solved it by changing the DataType of The entity's datetype for 'created_at' to java.sql.Date, whereas previously it was java.sqlTimestamp.

answered Apr 12, 2019 at 11:24

C Murphy

3532 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Comparing current date (Java) to a Timestamp in a DB (sql) using Hibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related