Oracle Dates and Java Dates and selecting the former into the later

I've been requested to move all of our DATE columns over to timestamps as the Java date object does not have a time element, when a query is thrown to the DB and this selects a date column, the time section is automaticallly lost via
JDBC. This sounds like a bag of crock to me, I'm surprised that the easiest option is to needlessly convert an awful lot of columns to timestamps, just so that JDBC can get at the time portion. I'm also concerned that the implication of this is more than it just allowing us to get date / times into Java. What are the storage implications? or are Dates / Timestamps synonymous at an internal level like INTEGERS, FLOATS etc?

Thanks,

Mike, Received on Wed Jun 01 2005 - 07:48:52 CDT