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

From: <stephen.howard_at_us.pwcglobal.com>
Date: 1 Jun 2005 06:10:38 -0700
Message-ID: <1117631438.740047.318310@g43g2000cwa.googlegroups.com>

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