Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can you help me with JDBC getDate() error?

Re: Can you help me with JDBC getDate() error?

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Tue, 01 Feb 2005 18:14:32 -0800
Message-ID: <42003788.1050606@bea.com>

Spare Brain wrote:

> Hi,
>
> I am observing a strange error with the time portion of the java.sql.Date()
> when using resultSet.getDate() - it always seems to show 12:00:00.
>
> The following code prints 2004-10-27 11:00:00.0
>
> String dtStr = resultset.getString("PROMISEDATE");
> System.out.println(dtStr);
>
> The following code prints 2004-10-27 12:00:00
> java.util.Date dt = resultset.getDate("PROMISEDATE");
> System.out.println(new SimpleDateFormat("yyyy-MM-dd
> hh:mm:ss").format(dt));
>
> Any clue why the getDate screws up the time? Any remedies you may suggest?

Yes, because it's a Date (date only). Try getTimestamp(). Joe Weinstein at BEA

>
> Many thanks
> SB
>
>
>
Received on Tue Feb 01 2005 - 20:14:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US