Just wondering if you ever discovered how to cast a field before query execution.
I'm also pulling data from an AS/400 system, but my need for being able to accomplish the above is so that I can do a join on two date fields, one of which is represented as an integer (yyyyMMdd).
[Message sent by forum member 'blot21' (blot21)]
http://forums.java.net/jive/thread.jspa?messageID=270387