Hi,
Try this:
ReportQueryByCriteria query =
QueryFactory.newReportQuery(YourClass.class, criteria);
query.setAttributes(new String[] { "char(dateField, 'ISO')", "anotherField" });
yourPersistenceManager.getBroker().getReportQueryIteratorByQuery(query);
I didn't test, but it should work.
On 3/31/06, ABOU LINA <[EMAIL PROTECTED]> wrote:
> Hi;
>
> AS400 as server.
> DB2 UDB as database .
>
> in a table we have a record whith the date "2999-12-31".
> when using ojb to retreive this record, the value of date is returned null.
>
> with an sql tool we have be able to get this date with the instruction
> select char(datetoshow, "ISO")...
> we have also verify that ojb generate select datetoshow without char(...,
> "ISO").
>
> best regards,
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]