Hi!, I have a class 'A' with a persistent attribute of type java.sql.Date :
.....
private java.sql.Date fecha;
.....
<property name="fecha" column="A_Fecha" type="date"/>
......
then I do this:
....
A a = new A();
a.setFecha(new java.sql.Date(System.currentTimeMillis()));
session.save(a);
...

When I look the database column always the hours, minutes and seconds are the same "12:00:00 p.m." but I need to differentiate it.
The database column type is "datetime".
Any Help?
Thanks.

[b]Hibernate version:2.1.4[/b]

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:Microsoft SQL server 7.0[/b]

[b]Debug level Hibernate log excerpt:[/b]

Map the property using a timestamp type instead of date.

For your info:
- date Hibernate type maps to a Date (without time)
- time Hibernate type maps to a Time (without date)
- timestamp maps to a datetime