File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Getting Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Getting ".0" extra in date !!" Watch "Getting ".0" extra in date !!" New topic

Getting ".0" extra in date !!

Prady Asmar

Joined: Feb 08, 2002
Posts: 1
I am using Oracle-8i as DB. I am using thin driver to connect to Oracle thru Java. In Oracle I have table name testdate having field datecol as date type.
I am following NLS_DATE_FORMAT as 'yyyy-mm-dd hh24:mi:ss' in the Oracle.
Now problem is when I fired query Select datecol from testdate from Java class It gives datecol return value as 2002-02-09 04:34:00.0
Why this .0 is appended in the result ???
One strange thing is that when I fired same query in the SQL prompt of ORACLE it gives proper result as 2002-02-09 04:34:00
Please help me ASAP.It's Urgent !!

Prady Asmar
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

How is this difference causing you problems? It seems like the data is correct, just formatted differently. If you want the date in a certain format then you just use SimpleDateFormat after you retrieve the date, and make it any format you want. It would also help if you posted the code that was giving you trouble.
Madhav Lakkapragada
Ranch Hand

Joined: Jun 03, 2000
Posts: 5040
Your name doesn't agree with the javaranch guidelines. Please take a moment and edit your profile after reviewing the guidelines at
Please change your Publicly Displayed name to follow the guidelines.
thanks for your cooperation.
- satya

Take a Minute, Donate an Hour, Change a Life
I agree. Here's the link:
subject: Getting ".0" extra in date !!
It's not a secret anymore!