Here i have a problem with date.
i am storing a date as sting in oracle9i the format is
while it is retrieving it gets changed.
in to 2003-01-19 00:00:00: like
how can i get the original one from database.
That's easy to format date .
Simply use a DateFormat object
Here is a sample of code adapted from Sun tutorial ...
//your code here
Date date = resultSet.getDate(index);
// check Sun tutorial for others formaters
today = new Date();
dateOut = dateFormatter.format(today);
System.out.println(dateOut + " " + currentLocale.toString());
Hope it helps ....
Try to change your retrieval code from the sql to something like
select to_char(yourDate, 'DD-MON-YYYY') genericName from yourDB
That should return a string in the form of the way you're storing it.