<div>
<br />
haven't got access to test the cc yet - so go with <br />
<br />
to_char(your_dt,'yyyy-mm-d<wbr />d')<br />
<br />
put a to_date round that if you need it back in date format for any reason.<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I am tyring to convert date type in informatica from DDMMYY TO ccyy-mm-dd . its urgent can you plase help.<br />
<br />
Thank you
</div>
</div>


I am tyring to convert date type in informatica from DDMMYY TO ccyy-mm-dd . its urgent can you plase help.

Thank you

to_char(your_dt,&amp;#39;ccyy-mm-dd&amp;#39;);
  


haven&amp;#39;t got access to test the cc yet - so go with 

to_char(your_dt,&amp;#39;yyyy-mm-dd&amp;#39;)

put a to_date round that if you need it back in date format for any reason.



how do i convert  a date type ddmmyy to ccyy-mm-dd

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.