Can you help me with JDBC getDate() error?

[Spare Brain]

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?

Many thanks
SB

[Joe Weinstein]

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

[Spare Brain]

"Joe Weinstein" <jo*******@bea.com> wrote in message
news:42**************@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

That worked!!! Thanks Joe.
SB