Hi,
In my class , the code :
String q1 ="select to_char(startdate , 'dd/mm/yy hh:mi:ss') from emp";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(q1);
while(rs.next())
{
System.out.printl(rs.getString(1));
}
The o/p: 2001-01-20 10:00:00 .
But, shouldnt it print 20/01/01 10:00:00 since i am getting the column value using rs.getString(x) and also in query i am
using to_char(x,x) for the required format.
Do i have to set some values at the
java side .
I am using oracle
JDBC driver.
Any help is appreciated.
thanks
Naresh.
[This message has been edited by Naresh Babu (edited April 28, 2001).]