SAP HANA TO_DATE()

[Former Member]

How can I convert a date format such as "Wednesday,22 January, 1960" using TO_DATE()??

I want to insert the return value of todate()  to a date column and Hana accepts date in yyyy-mm-dd format only.

Thanks in advance for help.

Praveen S

[former_member184768]

Hi Praveen,

Here you go:

select to_date(replace(substr_after('WEDNESDAY,22 January, 1960', ','), ',', ''), 'dd MONTH yyyy') from dummy;

Please find here all the date formats that can be used in the TO_DATE function.

Regards,

Ravi