Skip to Content
-1

HOW TO CONVERT 'YYYY-MM-DD' FORMAT TO 'DD/MM/YYYY'

Jan 09 at 12:55 PM

83

avatar image

Hi Experts,

I need to create one calculation view and consume in WEBI. The problem is, in HANA date format is YYYY-MM-DD but in WEBI date format is 'DD/MM/YYYY'.

I can write code to change the date format however i need but it is coming in nvarchar data type but i need it in date datatype so that i can do daysbetween() operation on that.

Please help

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers