How to convert a string to date in SAP HANA SQL select statement?

Question

How do i convert a string '20120215' to a date format YYYY-MM-DD (2012-02-15) in a SQL SELECT statement?

I am using SAP HANA SQL.

Solution 1

SELECT TO_DATE('20100112', 'YYYYMMDD') "to date" FROM DUMMY;

Solution 2

This should work:

SELECT TO_VARCHAR(TO_DATE('20120215', 'YYYYMMDD'), 'YYYY-MM-DD') "to date" FROM DUMMY;

As a_horse_with_no_name mentioned, you can use the SAP HANA SQL and System Views Reference for help on writing queries.