This is a simple class I use to format date from VOs to Form and vice versa. Hope it's helpful
import java.text.DateFormat; import java.text.Format; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; public class FormatUtility { public FormatUtility() { } public static String formatDate( String date ) throws ParseException { Format formatter = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss.S" ); Date dateD; try { dateD = ( Date )formatter.parseObject( date ); formatter = new SimpleDateFormat( "dd-MM-yyyy" ); date = formatter.format( dateD ); } catch( NullPointerException e ) { // Do nothing } catch( ParseException e ) { // Do nothing } return date; } public static Date getDate( String dateStr ) throws Exception { DateFormat df; SimpleDateFormat sdf = new SimpleDateFormat( "dd-MM-yyyy" ); Date date = sdf.parse( dateStr ); return date; } } -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:53 PM To: [EMAIL PROTECTED] Subject: Dateformat for MSSQL DB Hello, i want to parse a date from a inputfield and write it to DB (MSSQL Server) is there a method to format a date for MSSQL ? or for ODBC Datasources ? something like: DateFormat df ......., date = df.parse() ....... date = df.FormatForODBC() ..... Mit freundlichen Grüßen Christian Reps, Dipl. Inf. (FH) Web Applications --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]