title: SQL INSERT system date into table
body: <p>I have created a table called "myTable" with a column called CURRENT_DATE and it's data type is "DATE". When I programatically update my table, I also want to place a timestamp or system date in the CURRENT_DATE field. A portion of what I am doing is shown below, but it is not working. I would think this would be easy, but... Can you help?</p>
  
  <pre><code>//System date is captured for placement in the CURRENT_DATE field in myTable
   java.util.Date currentDate = new java.util.Date();
  ...
  stmt.executeQuery("INSERT INTO myTable (NAME, CURRENT_DATE) VALUES (' " + userName + " ', ' " + currentDate + " ')  ");      
  </code></pre>