title: The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007
body: <p>Am facing Issue with date format while running Informatica mapping with database db2.</p>
  
  <p>Effective date coming from input is "2020-03-17 00:00:00.000000000". </p>
  
  <p>But on passing to stored procedure I called in mapping it is reading it in format <strong>"03/17/2020 00:00:00.000000000"</strong> which causes Informatica to throw the following exception into the Informatica session logs.</p>
  
  <pre><code>Severity    Timestamp   Node    Thread  Message Code    Message
  ERROR   4/2/2020 11:53:34 AM    ecrmqetl    TRANSF_1_1_1    CMN_1022    Database driver error...
  
  CMN_1022 [ [IBM][CLI Driver][DB2/AIX64] SQL0180N  The syntax of the string representation of a datetime value is incorrect.  SQLSTATE=22007  sqlstate = 22007
  
  Database driver error...
  Function Name : ExecuteSP
  
  Native error code = -180
  Database driver error...
  Function Name : ExecuteSP
  
  Native error code = -180]
  </code></pre>
  
  <p>Any help is much appreciated.</p>