Calculated Column

[Former Member]

Hi there,

I'm trying to make two calculated columns from Timestamp column (yyyy-mm-dd hh:mm:ss), into Date (yyyy-mm-dd) and Time (hh:mm:ss). I was playing around with a few options like leftstr("ACTIVITYDATE",9) and it said it was a valid expression but when I went to save and validate I recieved an error.

Thanks,

Connor

[former_member184768]

Hi Connor,

Can you please try component function. Please search for "Functions used in Expressions" in HANA F1 help and check the component function.

component(date, int): the int argument may be int the range 1..6, the values mean year, day, month, hour, minute, second, respectively. If a component is not set in the date, the component function will return a default value, 1 for the month or the day, 0 for other components. The component function may also be applied to longdate and time types.

You can join different component values to get the data in the required format.

Regards,

Ravi