title: check for 'null' timestamp values
body: <p>I wanted to check if a field has a &quot;null&quot; value. If so, I wanted to replace the &quot;null&quot; with a NULL value. This works for normal fields:</p>
  <pre><code> SELECT NULLIF(JSON_DATA:&quot;TO_Creator&quot;::string, 'null') as &quot;TO_CREATOR&quot; FROM TABLE
  </code></pre>
  <p>However, it doesn't work with timestamps :</p>
  <pre><code>NULLIF(JSON_DATA:&quot;TO_Collected_Date_Time&quot;::timestamp_ntz, 'null') as &quot;TO_COLLECTED_DATE_TIME&quot;,
  </code></pre>
  <p>This would later throw errors that:</p>
  <pre><code>SQL Error [100035] [22007]: Timestamp 'null' is not recognized
  </code></pre>
  <p>How can I check the same thing for NULL values within the timestamp field too?</p>