Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

CMP Date sybase  RSS feed

 
Jeffrey.Boon.Hock Ng
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Has anyone able to find record using date?
- CMP
- JBoss4
- has tried using Jboss-ql and ejb-ql (both return no result)
- select object(c) from tableX as c where c.recDate=?1
- have change the recDate to have all hh:mm:ss to 00:00:00
- date element remain enchanged.
- calendar.set(Calendar.DAY_OF_MONTH, 10)
- calendar.set(Calendar.MONTH,10) [November]
- calendar.set(Calendar.YEAR, 2000)

or is there any other way to find record by date?

understand that sybase require the exact timestamp but apparently in real situations, the search with exact time requirement is not required and unnecessary. Use of convert is not allowed in jboss-cmp

please advise
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!