<div>
Awesome, it works! I used<br />
<br />
FROM_TZ(TO_TIMESTAMP(z.&quot;PX<wbr />ASSIGNDATE<wbr />TIME&quot;, 'yyyy-mm-dd&quot;T&quot;hh24:mi:ss.F<wbr />F&quot;Z&quot;'), 'GMT') AT TIME ZONE 'US/Eastern'<br />
<br />
Thank you very much
</div>


<div>
glad I could help.<br />
<br />
the reason NEW_TIME didn't work is NEW_TIME only works on dates, not timestamps.<br />
<br />
So, when you passed in a timestamp, it converted it implicitly to a date and then returned a date, hence the missing milliseconds.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am trying to convert a Gregorian date format to regular timestamp in Oracle SQL. Also, I need that time to account for Daylight savings time. Here is syntax I used but using NEW_TIME cuts the milleseconds from the timestamp. How can I account for millesonds and still do the DST. Please assist. Thank you<br />
<br />
Actual Column (Assign Time) : 2015-05-27T17:07:12.065Z<br />
Expected Result: 5/27/2015 12:07:12.065000000 PM<br />
Received outcome using New_time: 5/27/2015 12:07:12 PM<br />
<br />
<br />
NEW_TIME (<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TO_TIMESTAMP (z.&quot;PXASSIGNDATETIME&quot;,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'yyyy-mm-dd&quot;T&quot;hh24:mi:ss.F<wbr />F&quot;Z&quot;'),<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'GMT',<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'EDT'),
</div>
</div>


Hello,

I am trying to convert a Gregorian date format to regular timestamp in Oracle SQL. Also, I need that time to account for Daylight savings time. Here is syntax I used but using NEW_TIME cuts the milleseconds from the timestamp. How can I account for millesonds and still do the DST. Please assist. Thank you

Actual Column (Assign Time) : 2015-05-27T17:07:12.065Z
Expected Result: 5/27/2015 12:07:12.065000000 PM
Received outcome using New_time: 5/27/2015 12:07:12 PM


NEW_TIME (
             TO_TIMESTAMP (z."PXASSIGNDATETIME",
                           'yyyy-mm-dd"T"hh24:mi:ss.FF"Z"'),
             'GMT',
             'EDT'),

Convert Gregorian Date to timestamp in 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.