Oracle9i backwards compatibility
445349Jun 8 2005 — edited Jul 6 2005We have just upgraded to Oracle 9i from Oracle8 and we are running into issues with Date vs Timestamp.
Oracle8 did not have the concept of a Timestamp data type, but the Date type was sufficient since it stored time information. In our java code we always used CallableStatement.setTimestamp(...) without any problems. Now that we migrated to Oracle 9i, we are running into SQL Exceptions:
ORA-01830: date format picture ends before converting entire input string
From what I have read, this is because the Date type in the database no longer contains time information. Is there some way of using the most recent drivers without modifying the database structure? Is there a system property we can set (we saw something about setting oracle.jdbc.V8Compatible=true or oracle.jdbc.V8Compatibility=true but that isn't working for us)?
If I alter a DATE column and convert it to a TIMESTAMP column, will I lose any information currently stored in the table?