Question Re: Format Date function in SAP Data warehouse Cloud in Technology Q&A

Format Date function in SAP Data warehouse Cloud

arvshar2 — Mon, 13 Dec 2021 11:29:49 GMT

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_meiswinkel — Mon, 13 Dec 2021 11:50:26 GMT

Hi Arvind,

does this link help maybe?

Thanks,
Jascha

arvshar2 — Mon, 13 Dec 2021 12:12:06 GMT

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

kpsauer — Mon, 13 Dec 2021 12:29:05 GMT

Hi arvshar11 ,

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

Best regards
KP Sauer

arvshar2 — Mon, 13 Dec 2021 14:20:28 GMT

Thanks Klaus, this helps...

Regards
Arvind

JaSoN_Luo — Tue, 14 Dec 2021 11:28:29 GMT

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