on 02-14-2017 8:43 AM
In HANA STUDIO, I used SQL function TO_NVARCHAR(''BLDAT'','YYYY/MM/DD') in Calculated Columns to convert the YYYYMMDD date in BLDAT into YYYY/MM/DD and made it.
But according to project's request, this conversion should be realized with Column Engine, not SQL. Please answer this question, if you have some good ideas, Thank u so much.
link for functions which can be used with Column Engine.
Using Functions in Expressions
You can use a combination of the DATE and FORMAT function. The DATE function to convert the BLDAT date string to a date which then can be used by the FORMAT function to create a NVARCHAR typed result in your format.
The expression for the column engine calculated column looks like following:
format(date("BLDAT"),'YYYY/MM/DD')
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
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.