• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HQL Doubt

 
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic