<div>
First of all: These are ISO 8601 date/time values.<br />
<br />
Then: You don't convert them. Store it as the appropriate <a href="https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1005946" rel="ugc">DATETIME data type</a>.<br />
<br />
Don't mix up data type and formatting (visual representation).
</div>


First of all: These are ISO 8601 date/time values.

Then: You don't convert them. Store it as the appropriate DATETIME data type [https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1005946].

Don't mix up data type and formatting (visual representation).

<div>
ah problem is I need to convert them to the given format in order to use the column with other tables
</div>


ah problem is I need to convert them to the given format in order to use the column with other tables

<div>
Correct your data model. We store data according to the domain base type.
</div>


Correct your data model. We store data according to the domain base type.

<div>
that's the one @ slightwv (䄆 Netminder)<br />
<br />
especially with cast(to_timestamp_tz(t.sta<wbr />rt_utc,'YY<wbr />YY-MM-DD&quot;T<wbr />&quot;HH24:MI:S<wbr />S.FF3TZHTZ<wbr />M') as date)<br />
<br />
thank you :)
</div>


that's the one @ slightwv (䄆 Netminder)

especially with cast(to_timestamp_tz(t.start_utc,'YYYY-MM-DD"T"HH24:MI:SS.FF3TZHTZM') as date)

thank you :)

<div>
thank you for your help : )
</div>


<div>
<div class="content wysiwyg-content">
hello,<br />
<br />
I have this data from an external company and after I import it into a table they send time stamps like this '2017-06-01T09:40:58.520+0<wbr />000'<br />
<br />
how can I convert it to 'DD-MON-YYYY HH24:MI:SS'<br />
<br />
Many Thanks
</div>
</div>


hello,

I have this data from an external company and after I import it into a table they send time stamps like this '2017-06-01T09:40:58.520+0000'

how can I convert it to 'DD-MON-YYYY HH24:MI:SS'

Many Thanks

convert time

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.