title: Pentaho date format issue
body: <p>my input excel sheet has the field with two different types of values column in the format YYYY/MM/DD </p>
  
  <p><a href="https://i.stack.imgur.com/c7hbR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c7hbR.png" alt="enter image description here"></a></p>
  
  <p>Now, when I have added the excel sheet into Pentaho the columns along with datatype I got which shows string datatype in the date formats column. which you can see below </p>
  
  <p><a href="https://i.stack.imgur.com/fJ5q2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fJ5q2.png" alt="enter image description here"></a></p>
  
  <p>After this, I tried to integrate with postgres but I am unable to find the result the error which I got attached below</p>
  
  <p><a href="https://i.stack.imgur.com/Td9yE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Td9yE.png" alt="enter image description here"></a></p>
  
  <p>Updated</p>
  
  <p>I tried with the given timestamp format <code>yyyy/MM/dd HH:mm:ss</code> this works fine for me but this format <code>yyyy/MM/dd hh.00.00</code> is not present in the format column.</p>
  
  <p><a href="https://i.stack.imgur.com/5Po4v.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5Po4v.png" alt="enter image description here"></a></p>