Legacy date storage. How?

Pugnax · **Joined:** Wed Aug 11, 2004 7:01 am **Posts:** 10

Hibernate version: 2.1.6
Name and version of the database you are using: Mysql

I have a Legacy database where the dates are stored in varchar(15) fields and as a Long value (eg seconds from 1970-01-01 00:00:00).

'001084109924846' is the representation of 2004-05-09 16:15 (YYYY-MM-DD HH:mm)

Can I make hibernate map this field to a Date field? If so, how?

Regards
Kristoffer

michael · **Posted:** Wed Aug 11, 2004 7:23 am

Use a custom UserType. should be trivial.

ernst_pluess · **Posted:** Wed Aug 11, 2004 7:24 am

You can create a UserType. See http://www.hibernate.org/189.html for a similar problem.

HTH
Ernst

shl · **Posted:** Wed Aug 11, 2004 7:24 am

Custom type (UserType) will help you.
http://www.hibernate.org/?cmd=srchdoc&q=UserType

shl · **Posted:** Wed Aug 11, 2004 7:26 am

Triple shot :)

Pugnax · **Joined:** Wed Aug 11, 2004 7:01 am **Posts:** 10

Thanks for getting me on the right track.

/Kristoffer