<div>
Hi,<br />
<br />
My table having below date formats also<br />
<br />
MM/DD/YYYY<br />
DD/MM/YYYY<br />
<br />
but your query retriving both formts ,need only DD/MM/YYYY format
</div>


<div>
<div class="content wysiwyg-content">
My table having one varchar2 column,which is having all type of data formats inserted to into this table.<br />
<br />
Now,i want to retrieve data which is records having DD/MM/YYYY format<br />
<br />
please let me know,how to write.
</div>
</div>


My table having one varchar2 column,which is having all type of data formats inserted to into this table.

Now,i want to retrieve data which is records having DD/MM/YYYY format

please let me know,how to write.

How to retrive data which is having only DD/MM/YYYY format

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.