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