title: How to query a timezone data type in oracle using the java time format
body: <p>I have the below timestamp with timezone data stored in  a table</p>
  
  <pre><code>create table sample(id number,last_modified_dt timestamp with time zone);
  
  select last_modified_dt from sample;
  
  last_modified_dt
  -----------------
  19-06-17 09:36:28.100452000 AM +00:00
  </code></pre>
  
  <p>My front end node.js application is trying to query using the below format,</p>
  
  <pre><code>'2017-06-19T09:36:28Z' (java timestamp format)
  
  
  select last_modified_dt from sample where last_modified_dt = '2017-06-19T09:36:28Z'
  </code></pre>
  
  <p>i tried using </p>
  
  <pre><code>select last_modified_dt from sample where last_modified_dt = TO_TIMESTAMP('2017-06-19T09:36:28Z','YYYY-MM-DD"T"HH24:MI:SS"Z"');
  </code></pre>
  
  <p>but it returns empty result, clearly i know something is missing, can you please help me out.</p>