Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Dates and Java Dates and selecting the former into the later
mike.jones_at_xenicom.com wrote:
> 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,
Hi Mike,
Use the getTimestamp method the ResultSet object. No need to convert datatypes.
Regards,
Steve Received on Wed Jun 01 2005 - 08:10:38 CDT