Hibernate Community • View topic - How to compare date using jpa

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to compare date using jpa

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

hadik

Post subject: How to compare date using jpa

Posted: Fri Jan 11, 2013 8:41 am

Newbie

Joined: Tue Dec 18, 2012 3:08 am
Posts: 1

Hello community,
I want to compare today date in my orm.xml and it should be a generic way that i should use it in any database.

Currently i am using following query which is only works with Oracle

Code:

select t from Task t where to_date(t.taskDate) = to_date(CURRENT_DATE);

I need to make working it with all other databases.(I tested it in sql server 2008 and it is not working).

Thanks and Regards,
Hardik Dave

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum