<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>



haven't got access to test the cc yet - so go with

to_char(your_dt,'yyyy-mm-dd')

put a to_date round that if you need it back in date format for any reason.



<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

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.