title: Casting date 'yyyy-mm-dd' from a Widget to a timestamp error
body: <p>I have a widget called 'filedate' where you can specify a date, were you enter the date in the format 'yyyy-mm-dd', my example will use '2019-10-01' .</p>
  
  <p>I get the value from the widget with the following:</p>
  
  <pre><code>val fileloaddate = dbutils.widgets.get("filedate")
  </code></pre>
  
  <p>If I print the fileloaddate, it shows 2019-10-01, I need to use it in a query so if I do a 'select to_timestamp(${fileloaddate}, "yyyy-mm-dd")' it errors as it's seeing the variable as '((2019 - 8) -18). If I cast the string to a date, for example</p>
  
  <pre><code>select to_timestamp(to_date(${prundate}), "yyyy-mm-dd")
  </code></pre>
  
  <p>with the error of 'cannot resolve 'CAST(((2019 - 8) - 18) AS DATE)'</p>
  
  <pre><code>select to_timestamp(to_date('2019-10-01'), "yyyy-mm-dd")
  </code></pre>
  
  <p>works fine. I have googled around the answer but can't seem to see what I doing wrong.</p>
  
  <p>thanks</p>