Format Date function in SAP Data warehouse Cloud

[arvshar2]

Hi, I need to covert Datetime to Date in SAP Data warehouse Cloud (SAP DWC). I do not see Format Date function. Any clue would help.

[jascha_kanngiesser]

Hi Arvind,

does this link help maybe?

https://help.sap.com/viewer/c8a54ee704e94e15926551293243fd1d/cloud/en-US/6d624a1956234d818d0bfdc77cb...

Thanks,
Jascha

[jasonluo]

There are standard data type conversation DWC, you can do a quick search as highlighted...

[arvshar2]

Thanks Klaus, this helps...

Regards
Arvind

[kpsauer]

Hi arvshar11 ,

just use the the to_date function to convert it like in the following example.

Best regards
KP Sauer

[arvshar2]

Thanks Jascha. I do not see changing format date function like Datetime to Date.