title: HANA Error while parsing Date
body: <p>I'm trying to do this </p>
  
  <pre><code>CREATE PROCEDURE Create_test(IN datefrom date
  )
  as
  
  begin
  select add_years('0',years_BETWEEN('0', :datefrom)-1 )from dummy;
  end
  </code></pre>
  
  <p>When I run it it's fine, with no error, the procedure is created. But when I try to call the procedure it's give me this error</p>
  
  <blockquote>
    <p>SAP Hana Database Error: invalid DATE, TIME or TIMESTAMP value: Error
    while parsing 11/11/2018 12:00:00 AM as DATE at function
    <strong>typecast</strong>() (at pos 31)</p>
  </blockquote>
  
  <p>Please help</p>