title: To store a date in mySQL as dd/MM/yyyy format through Netbeans, but mySQL generally takes yyyy/MM/dd
body: <p>I entered the following codes. my goal is to store a date in mySQL as dd/MM/yyyy format. But mySQL generally takes yyyy/MM/dd.</p>
  
  <pre><code>    String d=(((JTextField)jDateChooser1.getDateEditor().getUiComponent()).getText()); 
      Statement stmt = db.conn.createStatement(); 
      String sql = "insert into diag.current " +     
                   "values'"+col1+"','"+col2+"','"+java.sql.Date.valueOf(d)+"','"+col4+"')";    
      stmt.executeUpdate(sql);
  </code></pre>
  
  <p>I right clicked on the jDateChooser1 and clicked on Customized code, and entered :</p>
  
  <pre><code>jDateChooser1= new com.toedter.calendar.JDateChooser("dd/MM/yyyy","##/##/####",'_');
  </code></pre>
  
  <p>Now please let me know where i am making the mistake. I will be grateful if someone solves this. Thanks in Advance. I hope i portrayed clearly...</p>