on 10-09-2013 2:20 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.