title: How to convert a TZ Datetime to Timestamp(3) in Flink SQL
body: <p>How do you convert a DateTime with the <code>TZ</code> to Timestamp(3) in Flink SQL v1.13?</p>
  <pre><code>TO_TIMESTAMP('2021-12-16T20:29:37Z', 'yyyy-MM-dd HH:mm:ss') //returns NULL
  </code></pre>
  <pre><code>TO_TIMESTAMP('2021-12-16 20:29:37', 'yyyy-MM-dd HH:mm:ss') //returns 2021-12-16T20:29:37
  </code></pre>
  <pre><code>TO_TIMESTAMP('2021-12-16T20:29:37', 'yyyy-MM-dd HH:mm:ss') //returns NULL, which is silly because this was the result from the 2nd example
  </code></pre>
  <p>It does not accept the <code>T and Z</code>, however the conversion result for a &quot;clean&quot; date has the <code>T</code>. But if I try the reverse operation, it returns null.</p>