title: Oracle date data type problem - I get wrong format as result in table
body: <p>I need to set a column with date data type TO_TIMESTAMP to correct format to insert some data with merge into declaration.</p>
  <p>The table.column = settings.data
  The insert value as example: '28.01.2022 14:07'
  But column is set as TIMESTAMP(6) format.
  So need this to insert as: '28.01.2022 14:07:00,000000'</p>
  <pre><code>DECLARE
  PROCEDURE settings_import
  (
  in_id IN NUMBER
  in_data IN TIMESTAMP
  )
  IS
  BEGIN
  MERGE INTO settings a
  using (select in_id AS ID, in_data AS data from dual) b
  on (a.ID = b.ID)
  when not matched
  then
  INSERT into settings (ID, data) values (ID, data)
  when matched
  update set a.data = b.data
  END settings_import;
  BEGIN
  settings_import (12, '28.01.2022 14:07');
  END;
  /
  </code></pre>
  <p>When I try this I get in column data this entry, but it's wrong: 28.01.2020 22:14:07,000000
  right should be: '28.01.2022 14:07:00,000000'</p>
  <p>When I try in the values (b.ID, TO_TIMESTAMP(b.data, 'DD.MM.YYYY HH24:MI:SS.FF')
  I get this error: <strong>ORA-01830: date format picture ends before converting entire input string</strong></p>
  <p>How can I fix this? thank you!</p>