Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DateTime Problem

713200Sep 18 2009 — edited Sep 18 2009
Hi there,

We are using Oracle 11g, moved(with Export/Import method) our database to x64 Windows Server 2008 , I were using a Java stored procedure like

DateFormat sdfFormatter = new SimpleDateFormat("HH:mm:ss");
Date dtNow = new Date();
Date dtLivre = new Date();
...
dtNow = sdfFormatter.parse(sdfFormatter.format(dtNow));
dtLivre = sdfFormatter.parse(rsTimeTable.getTime("departure_time").toString());
Long lngDif = dtNow.getTime() - dtLivre.getTime();
...
That code piece was working old server(x32 Windows Server 2008) but on new server its giving an error like ' Unparseable date: "16:01:01" ' , I installed JDK 1.6 on new server that code is working well. I checked Regional Settings too , booth server have same settings. I'm gonna crazy. Really this is so important for me ... Thx for help ...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2009
Added on Sep 18 2009
4 comments
456 views