I had to create entity-classes for db tables which already existed and which I can only read but not modify.
One problem with those tables is their bad design...
For example, one columns type is varchar but it contains a date formatted like this: "2012-08-08 14:23:48"
Now I need to do a query which checks, that this date is before another date (my parameter). This means I need hibernate to handle the varchar column as a Date, Timestamp, Calendar or whatever object which can be used in a query for comparisons.
Is there any way to handle a varchar-columns as ad "real" date? Using annotations, casts, ...?
Any help is appreciated!
subject: casting varchar to Date/Calendar ? (DB table is readonly!)