Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Getting Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Getting ".0" extra in date !!" Watch "Getting ".0" extra in date !!" New topic
Author

Getting ".0" extra in date !!

Prady Asmar
Greenhorn

Joined: Feb 08, 2002
Posts: 1
Hello
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 !!
Thanks


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.
Jamie
Madhav Lakkapragada
Ranch Hand

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


Take a Minute, Donate an Hour, Change a Life
http://www.ashanet.org/workanhour/2006/?r=Javaranch_ML&a=81
 
Consider Paul's rocket mass heater.
 
subject: Getting ".0" extra in date !!
 
Similar Threads
date format
getting errors I can't explain...anyone can help out ?
problem with date calcaulation
date format
websphere 4.0.5 slow startup