<div>
I did alter session now date coming like 006-10-09
</div>


<div>
You apparently missed a &quot;y&quot;. &nbsp;You need four of them as sdstuber suggested. &nbsp;You apparently executed this (with just three &quot;y&quot; characters):<br />
<br />
alter session set nls_date_format='yyy-mm-dd<wbr />'; <br />
<br />
Correct version is: <br />
alter session set nls_date_format='yyyy-mm-d<wbr />d';
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have date_created datatype date showing in sql developer as 06-09-29 can I display it in yyyy-mm-dd format.<br />
<br />
Thanks
</div>
</div>


Hi,
I have date_created datatype date showing in sql developer as 06-09-29 can I display it in yyyy-mm-dd format.

Thanks

Correct date format in sql developer

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.