Skip to Content
0
Jul 10, 2020 at 05:33 AM

Convert time format from HH:MM:SS:FFn to HH:MM - HANA

1953 Views

Hello All,

I'm new to HANA modelling and I want to convert a time stamp for a column from the format 'HH:MM:SS:FFn' to HH:MM (only hours and minute).

I tried to create a calculated column on top of the actual timestamp and tried various functions. But none works.

Below is actual time stamp column and I'm trying to convert it into HH:MM. Is this possible?

Thanks,

Nivetha

Attachments

capture.jpg (28.3 kB)