title: How to format date in hana
body: <p>I need to format date in my hana sql, but I don't know how to. Something like this:</p>
  
  <pre><code> SELECT
   DATE_FORMAT(DATAS,'%Y-%m') as Dat 
  ,sum(SALES_VALUE) as Venda
  ,sum(SALES_QTY) as Qtd
  ,sum(SALES_VALUE) / sum(SALES_QTY) as  Preco
  FROM looqdata.data_store_sales as s
  inner join
  looqdata.data_store_cad as c
  on s.STORE_CODE = c.STORE_CODE
  where 1=1
  and DATAS between '2016-01-04' and '2016-02-10'
  and s.STORE_CODE in  (1,2) 
  group by DATE_FORMAT(DATAS,'%Y-%m') 
  </code></pre>