This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes storing dates using prepared statements Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "storing dates using prepared statements" Watch "storing dates using prepared statements" New topic

storing dates using prepared statements

prav ba

Joined: Jun 17, 2007
Posts: 12
hi all,
have got a method which converts java.util.Date to java.sql.Date and stores it to oracle 11g db.

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 ??

Paul Clapham

Joined: Oct 14, 2005
Posts: 19723

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

Joined: Jun 17, 2007
Posts: 12
aha !! thanks Paul.
I agree. Here's the link:
subject: storing dates using prepared statements
It's not a secret anymore!