Converting time stamp in informatica to date
<p>I want to display the time stamp in following format '2011-04-22 10:41:57.000' to date as '04/22/2011' but when it convert it to following form TO_DATE(TO_CHAR(Date), 'MM/DD/YYYY HH24:MI:SS') it is displaying as null.</p>

<p>I am planning to use substring after the conversion</p>

<p>Can someone please tell me where i am going wrong?</p>