title: Get String as Date in HSQL
body: <pre><code>select * 
  from employee 
  having to_date(date, 'DD/MM/YYYY HH24:MI:SS') = to_date('01/01/2012 10:00:00', 'DD/MM/YYYY HH24:MI:SS')
  </code></pre>
  
  <p>Column 'date' is a VARCHAR/STRING</p>
  
  <p>as to_date doesnt work in HSQL,  how can make the above query work in HSQL ??</p>