Oracle database Date to Timezone format yyyy-MM-dd'T'HH:mm:ss.SSSXXX
<p>I'm trying to retrieve a timestamp date field from database using a <code>Select</code> query such that the timestamp date should be returned as <code>yyyy-MM-ddTHH:mm:ss.SSSXXX</code> format. I'm able to process it using SimpleDateFormat class in Java, but when I am trying to run it as a simple select query in SQL Developer and couldn't find sources.</p>

<p>Field value in the database: <code>09-MAR-16 08.30.37.640392000 AM</code></p>

<p>Expecting to return:  <code>2016-03-09T08:30:37.640-07:00</code></p>