Share this page 

Insert the current dateTag(s): JDBC


It's good idea to use the JDBC escape function instead of using a specific DBMS function. This way, your code will be portable.
sql = "INSERT INTO CUSTOMERS VALUES("
    + "'" + custName + "'" + ","
    + "'" + custPhone   + "'" + ","
    + "  {fn now() }  )";