storing dates using prepared statements

[prav ba]

hi all,
have got a method which converts java.util.Date to java.sql.Date and stores it to oracle 11g db.

String val = "05/05/05";
DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
java.sql.Date bill_Date = null
try {
            java.util.Date day = dateFormat.parse(val);
            bill_Date = new java.sql.Date(day.getTime());
        } catch (ParseException ex) {
            Logger.getLogger(CacheDBImpl.class.getName()).log(Level.SEVERE, "ParseException while parsing billDate " + ex.getMessage());
            
        }

the problem is that when i look into the db the value stored is 05-05-0005 which is not correct since i would have thought the value stored would be 05-05-2005.

can anyone explain why this is happening ??

thanks.

[Paul Clapham]

This is nothing to do with JDBC at all. You simply have misunderstood SimpleDateFormat. Direct quote from its API documentation:

For parsing, if the number of pattern letters is more than 2, the year is interpreted literally, regardless of the number of digits. So using the pattern "MM/dd/yyyy", "01/11/12" parses to Jan 11, 12 A.D.

[prav ba]

aha !! thanks Paul.