<div>
or just manipulate the string you have:<br />
regexp_replace(20130516,'(<wbr />[[:digit:]<wbr />]{4})([[:d<wbr />igit:]]{2}<wbr />)([[:digit<wbr />:]]{2})','<wbr />\2/\3/\1')<wbr />
</div>


or just manipulate the string you have:
regexp_replace(20130516,'([[:digit:]]{4})([[:digit:]]{2})([[:digit:]]{2})','\2/\3/\1')

<div>
This was the best solution for me as it is the easiest to understand.. Thanks
</div>


This was the best solution for me as it is the easiest to understand.. Thanks

<div>
<div class="content wysiwyg-content">
This query gives me error ORA-01843: not a valid month<br />
<br />
the ship_date column which is the one i am trying to convert to 05/16/2013 format, is a NUMBER column in 20130516 format. <br />
<br />
I've also tried to_char(ship_date, 'MM/DD/YYY') which gives me error ORA-01481: invalid number format model<br />
<br />

<pre><code id="code-10-28130595-1">select
TICKET_ID AS &quot;ID&quot;,
VENDOR,
CONTRACT,
to_date(SHIP_DATE, 'MM/DD/YYY'),
trim(' ' from PO_NUMBER) PO_NUMBER,
trim(' ' from FEEDER_SCHOOL) FEEDER_SCHOOL,
CASE WHEN trim(' ' from CODE) = NCSCODE.ITEM THEN NCSCODE.CODES END CODE, 
UNIT_PRICE,
QTY,
to_char(QQTY, '9999.99') AS TOTAL_COST, 
' ' AS DESCRIPTION
from (week join S on feeder_school = FS and SHIP_DATE = SD) join NCSCODE on ITEM = trim(' ' from CODE) ;</code></pre>
</div>
</div>


This query gives me error ORA-01843: not a valid month

the ship_date column which is the one i am trying to convert to 05/16/2013 format, is a NUMBER column in 20130516 format. 

I've also tried to_char(ship_date, 'MM/DD/YYY') which gives me error ORA-01481: invalid number format model

(CODE)

help with query, date 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.