Skip to Content
0
Sep 20, 2019 at 02:23 PM

How to derive Date and time from Column of type decimal?

693 Views

Hi friends

How to derive date and time from below column of type decimal. I have this table in HANA View. I have created two calculated column date and time. Is there any function available to convert, please share your input. Thanks

Column 1 ( Type Decimal)

20,190,816,055,102

20,190,719,054,613

Required Output:

Date(YYYYMMDD) Time(HHMISS)

20190816 055102

20190719 054613

Data in Source table

Regards

Dinesh