aspose file tools*
The moose likes Object Relational Mapping and the fly likes casting varchar to Date/Calendar ? (DB table is readonly!) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "casting varchar to Date/Calendar ? (DB table is readonly!)" Watch "casting varchar to Date/Calendar ? (DB table is readonly!)" New topic
Author

casting varchar to Date/Calendar ? (DB table is readonly!)

Will Zelan
Ranch Hand

Joined: Apr 15, 2012
Posts: 56

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!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: casting varchar to Date/Calendar ? (DB table is readonly!)