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.

Storing dates as varchars is not a good idea. You could use a function to cause the dbms to convert the string into a date so the query executes sensibly, but what you really want to do is use a sensible database schema.

Its the user's request to use the ddMMyyyy format in the web interface. I wanted to save on convert back and forth the date if i used a datetime object in the dbms thus i used string.

Now i need to compare this string with a date object parameter to the query.Any temporary casting or conversion functions which i can use in HQL.Thanks.

From my reply to your other post:

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.