Working with Dates

[Tony Evans]

I am writing a web appliction which takes in a date in the format of 02/05/2004.
I need to format the date and then insert it into an Oracle DataBase which takes Dates in the format of 02/May/2004.
I am not sure of hwo to write the code but this is my effort:
String aDate = "02/04/2004";
String formattedDate = null;
DateFormat dateFormatter;
Locale lc = Locale.UK;

Date date = null;

dateFormatter = DateFormat.getDateInstance(DateFormat.DEFAULT,lc);
try
{
date = dateFormatter.parse(aDate);
System.out.println(date.toString());
}
catch(ParseException e)
{
System.out.println("Date Exception "+e);
}
It return an exception Date Exception java.text.ParseException: Unparseable date: "02/04/2004"
Thansk for any help.
Tony

[chi Lin]

try
DateFormat.getDateInstance(DateFormat.SHORT,lc);

        
dateFormatter = DateFormat.getDateInstance(DateFormat.DEFAULT,lc);

[Tony Evans]

Thanks that worked, I have decided to go rfor the Oracle solution though and translate and compare the date within a store procedre.
If anyone is interested this store procedure will take a string in of type 02-04-2004
and will translate it into 02-APR-2004.
CREATE OR REPLACE procedure TC_DATE(adate IN VARCHAR2)
IS
BEGIN
insert into DateTest values(TO_DATE(adate,'DD-MM-YYYY'));
END;
/
Thanks again for your help.
Tony