Just realise something interesting about Date in Java and SQL

[Farhad Rahmati]

Hey Guys

I was working on my project and and trying to find a way to store a date from JTextField to JavaDB database. I found a way to as the following code

DateFormat df = new SimpleDateFormat("dd/mm/yyyy");
Date entryDate = df.parse(pExpireDateText.getText());

java.sql.Date sqlDate = new java.sql.Date(entryDate.getYear(), entryDate.getMonth(), entryDate.getDate());
//some code 
//some code 
//some code 
 
insertNewProduct.setDate(7, sqlDate);

so, it's okay and working gets String, converts to java.util.date and converts the Java date to sql.date and sends to database

but the interesting thing is it sends the first month which is Jan.
any date you enter, it just converts to Jan, however the year and the day is Okay as you entered. it changes only the month to Jan

any idea how to solve it? if not then could you please provide any alternative to save an entered String in JTextField as a date in JavaDB database.

your help is appriciated
Thanks

[Christophe Verré]

The SimpleDateFormat for month is MM not mm.

[Farhad Rahmati]

Thank you very much Christophe

it is sloved, I am new in Java and it's my first project

Thanks again

[Christophe Verré]

Farhad Rahmati wrote:I am new in Java and it's my first project

Good luck

[Christophe Verré]

Farhad Rahmati,
Your post was moved to a new topic.
I moved your post to the Swing forum