Executing the SQL below returns 1 result.
Code:
select count(*) as y0_ from myTable this_ where this_.myDate between to_date('2010-10-21 23:15:12', 'yyyy-mm-dd HH24:MI:SS') and to_date('2010-10-21 23:15:12', 'yyyy-mm-dd HH24:MI:SS')
My hibernate code is
Code:
DetachedCriteria criteria = DetachedCriteria.forClass(myClass.class).add(Restrictions.between("myDate", date1, date1));
translates to be
Code:
select count(*) as y0_ from myTable this_ where this_.myDate between ? and ?
date1 = 2010-10-21 23:15:12
The SQL above returns count 0. Is this a bug or am I doing something wrong?
Login
FAQ
Search