Mark:
> You're right !! That does make a difference. Regrettably, that doesn't
> solve my problem, as we do store time information in our DATE fields.
Yes, it's going to be a problem with just about every Oracle database --
I haven't seen too many that actually use the TIMESTAMP data type.
Unfortunately, the Oracle JDBC driver identifies a DATE column as a
java.sql.Date, so SquirreL handles them that way.
I don't think it will be able to be fixed without some Oracle-specific
coding -- maybe that could be added to the Oracle plug-in?
Maury
--
Maury Hammel
Technical Associate
Cronus Technologies Inc. (CTI)
250 - 2nd Ave. South
Saskatoon, SK S7K 1K9 Canada
t. 306.652.5798 x107
http://www.cfactor.net
|