title: How to convert a JSON date to an Oracle date in local time
body: <p>Let's say today is 30-NOV-2016 at 00:00:00 in Europe (GMT+1) and a frontend JavaScript application <code>JSON.stringify(new Date(2016, 11-1, 30))</code> send a JSON (stringified) date to an Oracle backend.</p>
  
  <p>This date would arrive as the string <code>"2016-11-29T23:00:00.000Z"</code> and now I would like to convert this string to a proper Oracle DATE in the (again) local timezone (GMT+1).</p>
  
  <p>I expected</p>
  
  <pre><code>SELECT CAST(TO_TIMESTAMP_TZ('2016-11-29T23:00:00.000Z', 'FXYYYY-MM-DD"T"HH24:MI:SS.FXFF3"Z"') AT LOCAL AS DATE) FROM DUAL;
  </code></pre>
  
  <p>to do the trick, but this actually returns me the UTC date <code>29.11.2016 23:00:00</code> and not the correct local date <code>30.11.2016 00:00:00</code>.</p>
  
  <p>This should be quite straightforward but I cannot seem to figure out, what I'm doing wrong?</p>