title: Date format in hql
body: <p>I have hql like</p>
  
  <pre><code>hql="SELECT DISTINCT C FROM Client C 
  WHERE lower(str(C.name)) like '%"+sSearch
  + "%' OR str(day(C.birthday)) like '%"+sSearch "%';
  </code></pre>
  
  <p>As you can see, i can search sSearch in my table.</p>
  
  <p>But problem is that sSearch can have dd.MM.yyyy format or can not be a date (e.g. sSearch="John"), and DATE type has yyyy-MM-dd format in DB.</p>
  
  <p>I want to select date in needed format dd.MM.yyyy as string for using expression 'like'.</p>
  
  <p>Thanks.</p>
  
  <p>Solved this problem with</p>
  
  <pre><code>hql="SELECT DISTINCT C FROM Client C 
  WHERE lower(str(C.name)) like '%"+sSearch
  + "%' OR concat(str(day(C.birthday)),'.',str(month(C.birthday)),'.',
  str(year(C.birthday))) like '%"+sSearch "%';
  </code></pre>