Hellu there,

I notice that I have to use query.setCalendar() in my HQL to use the datetime sql field , but I notice that hbm2java generates java.util.Date members in my persist objects...
I think they both work fine, but what's the logica behind this ? and what is the way to go ? For example: should I use Calendar as member in my persist objects instead of Date ?? or just leave it like this ?

Please someo light on this issue
Ed

eh??


Do you understand how to use Hibernate date, timestamp, time types correctly? And their corresponding Query.setDate(), Query.setTimestamp(), Query.setTime()?

Yep... at least I think so..
. I understand the usage like is explained in the manual.... but I am a bit confused....

In the examples in the manual you use Calendar in your value persist objects... but the hbm2java generates sql datetime fields as java.util.Date types... which works well..

Also in the manual there does appear the mapping from Date(), Calendar to the SQL type Time, timestamp, Date... but no datetime...
Yeeeyyee the manual says: (or equivalent)... but datetime is not equivalent to Date , Time and timestamp... or not ????: datetime=Date+Time... or am I missing something here ??

So what is my equivalent for datetime ??

Ed

DATETIME is the MySQL implementation of the ANSI SQL type TIMESTAMP, which (speaking loosely) Hibernate represents as the "timestamp" type.

OK, thanx gavin.

I getting grazy of the sql types sometimes as MS gives his own interpretation of timestamp... I thought datetime is the sql ansi standard.

Tx,
Ed