```
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')

```

Column 'date' is a VARCHAR/STRING

as to\_date doesnt work in HSQL, how can make the above query work in HSQL ??