title: Getting ORA-01858 error while inserting time stamp
body: <p>My timestamp format in front end is like this</p>
  <pre><code>2020-7-23 14:36:43. 132000000
  </code></pre>
  <p>My timestamp in oracle db is like this</p>
  <pre><code>23-07-20 02:36:43.132000000 PM
  </code></pre>
  <p>I have changed the time format like below</p>
  <pre><code>private String OracleTsString(String createdDate)  {
          SimpleDateFormat inputFormat=null;
          SimpleDateFormat outputFormat = null;
          try {
          
            inputFormat = new SimpleDateFormat(&quot;yyyy-M-dd HH:mm:ss.SSSSSSSSS&quot;);
            Date date;
            date = inputFormat.parse(createdDate);
             outputFormat = new SimpleDateFormat(&quot;MM-dd-yy hh:mm:ss.SSSSSSSSS aa&quot;);
          
          }
     //Exception Handling
  </code></pre>
  <p>But when I try to insert the string into database , I am getting  <strong><strong>ORA-01858</strong>: a non-numeric character was found where a numeric was expected</strong></p>
  <p>Below is my  query</p>
  <pre><code>jdbcTemplate.update(query, 
                  editSftpBean.getSftpName(),
                  editSftpBean.getIp_address(),
                  editSftpBean.getPort_number(),
                  editSftpBean.getUserName(),
                  editSftpBean.getAuthentication(),
                  oracleTs//My converted string
  );
  </code></pre>
  <p>insert query::</p>
  <pre><code> INSERT INTO tabl_two (SFTP_NAME, IP_ADDRESS, PORT_NUMBER, USER_NAME, AUTH_TYPE,CREATED_DATE ) VALUES (?, ?, ?, ?, ?)
  </code></pre>
  <p>How can I resolve this?</p>