Hi all,


I've the following code:


Query query = dbSession.createQuery("from Job as job where job.dateCollected >= :dateStart");

query.setTimestamp("dateStart", DateTimeUtil.parse((String) request.getParameter("dateStart")).toDate());

It works fine if the dateCollected field is a Date Object in my Job class
Due to unforseen stuff, dateCollected has to be changed to a String Object.

How should i change the query?

The dateStart parameter is gotten from a text field in ddMMyyyy format (eg:15092005).

Thanks.

The easied fix I could see would be store the date in yyyyMMdd that way the higher string is the later date and just present in what ever format you want.

You can then set date start when you compare it to be a string in that format with simpledateformater.