title: Convert Date Format in Informatica
body: <p>I am trying to convert source field of DateTime attribute of format 03/08/2021 00:00:00 to target field of DateTime attribute to format 2021-03-08 00:00:00.</p>
  <p>I tried using <code>TO_DATE(TO_CHAR(DATE_CON,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')</code></p>
  <p>but got following error:</p>
  <blockquote>
  <p>TT_11132 Transformation [Expression] had an error evaluating output column [DATE_CON]. Error message is [&lt;&gt; [TO_DATE]: invalid string for converting to Date ... t:TO_DATE(u:TO_CHAR(t:&lt;03/08/2021 00:00:00&gt;,u:'YYYY-MM-DD HH24:MI;SS'),u:'YYYY-MM-DD HH24:MI:SS ')].</p>
  </blockquote>
  <p>How can I resolve this error? DataType of both source and target is DateTime.</p>