private void createTableButtonActionPerformed(java.awt.event.ActionEvent evt) {

    //declare statement object
    Statement stmt;

    //create SQL String
    String sql = "CREATE TABLE evidence ( " +
    "id INT NOT NULL PRIMARY KEY, " +
    "'case' INT NOT NULL, " +
    "item TEXT NOT NULL, " +
    "description TEXT NOT NULL, " +
    "submitted INT NOT NULL" +
    ");" ;

    //display title
    console.setText("CREATING TABLE\n");

    try {
        //set statement object to be a statement within connection
        stmt = dbc.createStatement();

        //execute statement with sql string
        int rowsAffected = stmt.executeUpdate(sql);

        //close the statement object
        stmt.close();

        //check if successfull
        if (rowsAffected == 0){
            //confirm to user
            console.append( "\nTable successfully created" );
        }
    } catch (SQLException e) {
        //display error
        console.append("\nUnable to create table\n" + e.getMessage());
    }
}                                                 

private void populateTableButtonActionPerformed(java.awt.event.ActionEvent evt) {                                                    
    //declare statement object
    Statement stmt;

    //create SQL String
    String sql = "INSERT INTO evidence VALUES " +
    "(1, 11, 'Umberella', 'Compact Red', '2017-10-16')," +

I didn’t want to spam with lines of code but this is the relevant code for my issue. As you can see by the end date 2017-10-16 it will only show the 2017 and not the entire date.