How to use to_date()to_char() in oracle for HQL

jackgong · **Joined:** Sun May 23, 2004 3:38 am **Posts:** 3

How to use to_date() and har() in oracle for HQL
other like date_format() in mysql for HQl

anthony · **Posted:** Sun May 23, 2004 3:57 am

have you tried it with 2.1.3 ?
what error do you get?

jackgong · **Joined:** Sun May 23, 2004 3:38 am **Posts:** 3

does 2.1.3 can resolve this problem

anthony wrote:

have you tried it with 2.1.3 ?
what error do you get?

david · **Posted:** Sun May 23, 2004 6:32 pm

It will not work since the select clause will not currently accept multiple argument db functions. There has been a lot of work on a new parser which will make this tivial to fix. Expect it as apart of the v2.2/v3.0 efforts.

hamzaiverson · **Joined:** Thu Apr 18, 2013 5:04 am **Posts:** 4

you can use the concatenation of concat(year(),month(),day())