title: Current date in SAP HANA
body: <p>Hello Everybody ,</p>
  
  <p>I am trying to write a small sql statement in HANA Studio in scripted calculation view .</p>
  
  <p>The example data set is shown above .
  If i want to select all the ships that are departing five days from prior today(4th December ,2017) and after today .What is the SQL fuction that i should use and how to figure out todays date in HANA studio and as well as the difference between todays date and date in each record.
  The output should be </p>
  
  <pre><code>  B           09/12/2017
    D           29/12/2017
  </code></pre>
  
  <p><strong>UPDATE 1</strong></p>
  
  <p><code>SHIP_NAME   DATE_OF_DEPARTURE(DD/MM/YYYY)
     A           15/12/2017
     B           09/12/2017
     c           30/12/2017
     D           29/12/2017</code></p>
  
  <p>Can anybody figure out any issues with this statement .Its not working .</p>
  
  <p><code>SELECT T1."SHIP_NAME" AS "Ship Name" , DAYS_BETWEEN (CURRENT_DATE,T1."DATE_OF_DEPARTURE") AS "Days Between" FROM “_SYS_BI”.“M_SHIP_DEPARTURE” as T1;</code></p>
  
  <p>@Lars Br.  a little help</p>