Skip to Content

SAP HANA convert nvarchar date in format MMM.yy to date

Jun 15, 2017 at 04:15 AM


avatar image
Former Member

I have got to create a hana calculation view where an output field must be MMM.yy (Jun.16). The view is going to be used by another tool and they can only provide the parameter in that format. I already have the column available in my calculation view in that format. The issue is when I crated an interval variable and I gave value as Mar.17 to May.17. It gave me Mar.17, Mar.18 and May.17 . as the variable is based off of nvarchar field.

How can I covert it to a date field , so that when the variable received data in such format, it will be treated as a date and not as a nvarchar.

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

0 Answers