title: Snowflake - How to split tuple of dates column while using in where clause
body: <p>We have a scenario to apply on below table (sample provided) to split the date_clmn of varchar type to each individual.</p>
  <pre><code>tableA
  
  emp_id  date_clmn
  123     (&quot;2021-01-01&quot;, &quot;2021-03-03&quot;)
  456     (&quot;2021-02-01&quot;, &quot;2021-04-03&quot;)
  </code></pre>
  <p>So, we have a scenario while inserting the data in the following table through dml operations.</p>
  <pre><code>For example1:
  
  DELETE FROM tableA WHERE cast(BEGIN(date_clmn) as DATE FORMAT 'YYYY-MM-DD') =current_date AND END(date_clmn) IS UNTIL_CHANGED ;
  </code></pre>
  <p>Which we need to convert to snowflake format, to take the first value and the second value from the date_clmn column <strong>where we are considering the &quot;date_clmn&quot; is in varchar datatype</strong>.</p>
  <p>So, in snowflake we need to know how to get the first and second value from all rows when we are accessing the column in the filter clause ?</p>
  <p>This is actually the teradata period datatype, which we want to equivalate in snowflake.</p>