title: converting TimeDate() string to a DATE data type
body: <p>I<code>m trying to convert a TimeDate function</code>s result in DataStage to a DATE data type but i could not reach any solution. 
  let go deeper. i`m trying to read from a file which contains 3 columns : name, ID and ACC#. then update a database table. THIS TimeDate function is added in the transformer in order to note down the table update date.<br>
  How can i convert this TimeDate to a DATE datatype yyyy-mm-dd. please someone help me.</p>
  
  <p>NOTE: the datadabe i`m using is oracle.</p>