0 Replies Latest reply on Nov 19, 2007 6:40 PM by Troy Tarrrant

    between not working on hypersonic db

    Troy Tarrrant Newbie

      Hi,

      Not sure where to post, but... the following ejbsql:

      from UploadRecord where date between :start and :endDate
      


      does not work on the hypersonic db, but does work on other dbs like mysql. There is a boundary condition where if the start date in the db is 2007-11-01 00:00:00 then passing in a :start date parameter of Thu Nov 01 00:00:00 NZDT does not work on hypersonic but does work on mysql.

      If you change the date in the db to be 2007-11-01 00:00:01 then it works. But if you change the ejbsql to
      from UploadRecord where date >= :start and date <= :endDate
      

      it still doesn't work.

      These are my observations and what is going on here, has anyone else experienced this?

      jboss: 4.2.0.GA

      Troy