I gave CONVERT(VARCHAR(10),i.purchase_date,111) in hibernate query.

and i get a error like :


java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.MethodNode
\-[METHOD_CALL] MethodNode: '('
+-[METHOD_NAME] IdentNode: 'CONVERT' {originalText=CONVERT}
\-[EXPR_LIST] SqlNode: 'exprList'
+-[METHOD_CALL] MethodNode: '('
| +-[METHOD_NAME] IdentNode: 'VARCHAR' {originalText=VARCHAR}
| \-[EXPR_LIST] SqlNode: 'exprList'
| \-[NUM_INT] LiteralNode: '10'
+-[DOT] DotNode: 'invoice2_.Purchase_Date' {propertyName=purchase_date,dereferenceType=4,propertyPath=purchase_date,path=i.purchase_date,tableAlias=invoice2_,className=com.swanthalicense.model.Invoice,classAlias=i}
| +-[ALIAS_REF] IdentNode: 'invoice2_.Invoice_No' {alias=i, className=com.swanthalicense.model.Invoice, tableAlias=invoice2_}
| \-[IDENT] IdentNode: 'purchase_date' {originalText=purchase_date}
\-[NUM_INT] LiteralNode: '111'


Could any one tell me solution for this.

Thanks in advance.