Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers