• Post Reply Bookmark Topic Watch Topic
  • New Topic

HQL Doubt  RSS feed

 
lavanya Ananth
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am using the following as my HQl QUERY.

"select certificate.lastName, certificate.localRegistrationNumber , trunc(sysdate - (to_date(certificate.registrarAcceptDate,'MM/dd/yyyy')) as days from edu.ucdavis.edrs.valueobject.Certificate as certificate where ";

When i execute it , all fields get populated with values from database except the derived field (sysdate - (to_date(certificate.registrarAcceptDate,'MM/dd/yyyy')days. Can anyone help me with this?
 
Muhammadh Raffic
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi lavanya,
I hope you cant use a method which has two arguments. I mean the to_date function. It requires two arguments and hence it results in an error. For more clarifications check out the bugs list at the hibernate site.

Raffic.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!