String to Date conversion

[juanma]

Hi everybody,

I'm trying to convert a String to sql date value to update a database.
I'm new on Java and i cannot solve the following problem:

A user has an HTML form where he introduce a date value in an "input
type=text" cell.
when he submit the form i receive the request and must convert the string
value into a date value.

How can do that? I think solution is around DateFormat class...

Thanks in advance,


Juanma

[Ruchi Dhar]

I am assuming that your text field in the HTML is having MM/dd/yyyy format.

import java.text.*;
import java.util.*;
import java.sql.*;

public class DateConversion
{
public java.sql.Date getDate(String date)
{
//The format of the input date string
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
java.util.Date dd = sdf.parse(date);
//Oracle Date is in yyyy-MM-dd.
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
String jdbcDate = sdf1.format(dd);
return java.sql.Date.valueOf(jdbcDate);
}

public java.sql.TimeStamp getTime(String dateTime)
{
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy hh:mm:ss aa");
Date dd = sdf.parse(dateTime);
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.fffffffff");
String jdbcTime = sdf1.format(dd);
return java.sql.TimeStamp.valueOf(jdbcTime);
}
}


"juanma" <jmherreros@unisoft-x.com> wrote:
>
>Hi everybody,
>
> I'm trying to convert a String to sql date value to update a database.
>I'm new on Java and i cannot solve the following problem:
>
> A user has an HTML form where he introduce a date value in an "input
>type=text" cell.
> when he submit the form i receive the request and must convert the string
>value into a date value.
>
> How can do that? I think solution is around DateFormat class...
>
> Thanks in advance,
>
>
> Juanma
>
>