<div>
Oracle does not store dates in any particular format.<br />
<br />
To have Oracle display dates in a specific format, set the NLS_DATE_FORMAT parameter:<br />
<br />

<pre><code id="code-101140">ALTER SYSTEM SET NLS_DATE_FORMAT='DD-Month-YYYY';</code></pre>
</div>


Oracle does not store dates in any particular format.

To have Oracle display dates in a specific format, set the NLS_DATE_FORMAT parameter:



ALTER SYSTEM SET NLS_DATE_FORMAT='DD-Month-YYYY';

<div>
<div class="content wysiwyg-content">
Hi expert,<br />
<br />
I have the dataset which contains datatime formated &nbsp;as 12/06/2008 12:00:00, I need to reformat it as 12-June-2008 to store into ORACLE database, otherwise it give me error as ORA-01861: literal does not match format string<br />
<br />
can some one give me advise how to solve this issue.<br />
<br />
Thanks in advance<br />
<br />
Ying 
</div>
</div>


Hi expert,

I have the dataset which contains datatime formated  as 12/06/2008 12:00:00, I need to reformat it as 12-June-2008 to store into ORACLE database, otherwise it give me error as ORA-01861: literal does not match format string

can some one give me advise how to solve this issue.

Thanks in advance

Ying 

how to change datetime format from dataset and store into oracle

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.