title: How to get date and time separately in to two columns from a HANA unix timestamp field?
body: <p>The unix timestamp value is coming to HANA via data services from MySQL DB.</p>
  
  <p>I can however find the date using the following statement but wanted to know if there are any built in functions in SAP HANA or in Data Services Designer which can do this job? Also is there any way to get time from the result like we have TO_DATE for date other that RIGHT( )?</p>
  
  <p><code>SELECT TO_VARCHAR (ADD_SECONDS( '1970-01-01 00:00:00', "1452261405")) </code></p>
  
  <p>and it will return 2016-01-08 13:56:45</p>