Skip to Content
0
Jan 22, 2019 at 08:30 AM

Concatenate(Field1, Space, Field, space, Field3 etc) in Hana Studio Caculated View

159 Views

Greetings,

In SAP Hana Studio, Calculated View with Graphical option, I am trying to create a Calculated field as below

Conc(CONCAT(TO_VARCHAR(TO_DATE("FKDAT"),'MM'),'-',TO_VARCHAR(TO_DATE("FKDAT"),'MON'))

expecting the result of 01-Jan, 02-Feb, 03-Mar etc

But error is raised. Request you to guide me to resolve the following

Attachments