I use this utility class:
package com.itCom.util;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
/**
*
* @author Dao
*/
public class SQLDateConvertor {
/** Creates a new instance of SQLDateConvertor */
public SQLDateConvertor() {
}
public static String convertDateFormat(java.sql.Date date, String format)
{
DateFormat df = new SimpleDateFormat(format);
try {
return df.format(date);
} catch (Exception exp) {
return null;
}
}
public static java.sql.Date convertToSqlDateFormat(String
value,String format) {
DateFormat df = new SimpleDateFormat(format);
try {
Date date = df.parse(value);
return new java.sql.Date(date.getTime());
} catch (Exception exp) {
return null;
}
}
}
On 6/23/06, Niall Pemberton <[EMAIL PROTECTED]> wrote:
Commons Validator 1.3.0 has a whole set of easy to use
validation/conversion routines:
http://tinyurl.com/g526k
DateValidator validator = DateValidator.getInstance();
java.util.Date utilDate= validator.validate("06-apr-07", "dd-MMM-yy");
java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());
Niall
On 6/22/06, Chris Cheshire <[EMAIL PROTECTED]> wrote:
> try {
> java.sql.Date d = new java.sql.Date(new
> SimpleDateFormat("dd-MMM-yy").parse("06-apr-07").getTime());
> }
> catch (ParseException ex) {
> }
>
> Chris
>
> On 6/22/06, temp temp <[EMAIL PROTECTED]> wrote:
> > I have a string which I want to convert into a date .
> > The string 06-APR-07
> >
> > How can I convert this date into sql date ?
> >
> > Thanks
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Groups gets better. Check out the new email design. Plus there's
much more to come.
> >
>
> ---------------------------------------------------------------------
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
