The code snippet below shows to how to insert current date into a database table:

Java Code:
sql = "INSERT INTO CUSTOMERS VALUES("
    + "'" + custName + "'" + ","
    + "'" + custPhone   + "'" + ","
    + "  {fn now() }  )";