@Test public void Dates() { long current = System.currentTimeMillis(); int dayInMillis = 24 * 60 * 60 * 1000; Date start = new Date(current); ds.delete(ds.createQuery(Dates.class)); Dates d = new Dates(); d.setDate(new Date(current + dayInMillis)); ds.save(d); Date end = new Date(current + 2 * dayInMillis); assertEquals(d, query(dates).where(dates.date.between(start, end)).singleResult()); assertEquals(0, query(dates).where(dates.date.between(new Date(0), start)).count()); }