mysql - JOOQ how query for between dates -

i'm using jooq in project , need query data between 2 dates.

the sql query produces right data is

select created_on queue_token created_on between '2015-07-16' , '2015-07-17' , token_queue_id=1; 

the equivalent jooq query have written below doesn't give out required result

 create.select().from(com.database.tables.queuetoken.queue_token)                    .where(com.database.tables.queuetoken.queue_token.token_queue_id.equal(1))                     .and(com.database.tables.queuetoken.queue_token.created_on.between(new timestamp(fromdate.gettime())).and(new timestamp(todate.gettime())))                     .fetch(); 

the jooq query produces result produces records match fromdate. it's not working date range.

can here?

i think problem in passing timestamp or date and time (i not know java well). instead sending e.x. "2015-07-16", "2015-07-16 12:55:00" or "1436187300".

try debug value of new timestamp(fromdate.gettime()) first , if i'm right, try convert simple date without time.

to getting correct date value without time can use:

• java 8 package java.time localdate https://docs.oracle.com/javase/8/docs/api/java/time/localdate.html

• or lib joda time http://joda-time.sf.net/