date conflict

[vicky baba]

I am entering system date ..

java.sql.Timestamp ApprovedOn= null;

java.sql.Timestamp currDate = UtilClass.getSystemDateTime();
ApprovedOn = currDate;


pstmt.setTimestamp(16, ApprovedOn);


At this time it is entering time perfectly.
like
3/31/2005 5:42:21 PM
But when i fetch this value it is showing time with AM.

Please Help me i am at Client side Very urgent.with code please

Thanks in advance

[Baiju Scariah]

Why don't you use Calendar class instance...

[Horatio Westock]

At this time it is entering time perfectly. like 3/31/2005 5:42:21 PM

How do you know? Do you print out the date from your program, or do you look in the database directly using some other tool?

But when i fetch this value it is showing time with AM.

Please show the code you use to fetch the date.

[Pete Harris]

Vicky,

Without more info, this is impossible to diagnose, but as a wild stab in the dark, I'd suggest that something is not picking up the AM/PM string and reading the time as a 24 hour clock thing.

cheers, Pete