how to convert date yyyymmdd to yyyy:mm:dd in hana calculated coloumn

[prashant_kumar30]

Hi experts,

i have requirement in hana to display the date and time as shown below

          yyyy:mm:dd  and  hh:mm:ss

but as of now my date is displaying like yyyymmdd and time is displaying like hhmmss.

the date field is AUSVN  and AUZTV whose data type is dats(8) and tims(6).

kindly help how can i convert my date in to above said format through calculated column

Thanks

prashant

[chandan_praharaj]

Its quite easy. It is always better to try before posting these questions.

Just declare two columns in calc view with DATE and TIME. and another Calculated column where use format() function.

For Example :

[lbreddemann]

Ok, DATS and TIMS are ABAP character based data types.

You can convert them into date and timestamp data types - for that please do your homework and check the documentation, ok?