how to update one column of my table?

[Elahe Shafie]

Dear friends,
I want to read my table and write it again with updated data like(Wed Jan 19 16:26:37 PST 2001 and change it to 1/19/2001)so how can I update this column data through my servlet?
Any advice?
Many thanks,
Elahe

[Elahe Shafie]

or mybe it is clear to ask this way that how can I read date like this format from database:
Wed Feb 19 16:26:37 PST 2001
Wed Jan 02 12:22:40 PST 2002
and write it like:
2/19/2001
1/02/2002
I need to update all data in date column.
I hope it is clear this time...
Many Thanks,
Elahe

[Jamie Robertson]

You should read it out of the database as a Date, and then format it for the user:

Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select datecolumn from table where...");
if ( rs.next() )
{
java.util.Date day = new java.util.Date ( rs.getDate( 1 ).getTime() );
// Format the Date.
SimpleDateFormat formatter = new SimpleDateFormat ( "M/d/yyyy" );//or "MM/dd/yyyy" to force zeros on single digit months/days
String dateString = formatter.format( day );
System.out.println( dateString );
}
...

to update the database, get the formatted String date, parse it into a Date object, write the date object to the database:

String stringDate = "2/25/2001";
PreparedStatement ps = con.prepareStatement("update table set datecolumn = ? where...");
// Parse the Date.
SimpleDateFormat formatter = new SimpleDateFormat ( "M/d/yyyy" );
java.util.Date day = formatter.parse( stringDate );
 
//set the update parameter
ps.setDate( 1, new java.sql.Date( day.getTime() ) );
ps.executeUpdate();
...

Jamie