hi bobby,
be aware the addColumn.. expects the real name of the column. it does not translate attribute name into column name.
ojb does not provide dbms-independent handling of date attributes.
jakob
Bobby Lawrence schrieb:
Can anyone tell me the 'preferred' way to implement Date criteria in OJB?
I can't get ti work with the "addColumnEqualTo" method.
In many situtations, when I write SQL directly, I have to do some conversion to the field I am comparing against.
Year(<column>) = '2004'
or something like that...
It worked using the "addBetween" criteria and converting to a long, but it seems that depending on the underlying database, the Date datatype is handled differently. And in the situations where the database stores them as timestamps, converting between a Unix timestamp and the Java timestamp requires me to multiply or divide by 1000.
Anyone dealt with this before?
-- Bobby
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
