hi all,

i want to format date to string in hql select, for example i have purchasing data with transaction date in it:

class Purchase {

  private Date datePurchase

}

and i want to select date in a certain format, for example yyyyMMdd, can i do that in hql?

actually i can iterate through all purchase data returned by query, and start to format the date using SimpleDateFormat, but i don't want do that, i want to do it in hql, is it posible?

fyi, i just want to return the id and date string only, not all Purchase field.

thak you all for any help.