Skip to Content
1
Mar 07, 2014 at 12:06 PM

Timestamp conversion

6943 Views

Hi,

by definition timestmaps provide date/time in UTC. With knowledge of the timezone it should be possible to calculate the local date and time explicitly. But there is no such function available in HANA. I have a timestamp field on the DB (data type DEC15 or DEC21) and want to provide an additional calculated field, showing local date, or local date/time. There is function UTCTOLOCAL, but this requires wrong importing data formats:

utctolocal(datearg,timezonearg) since it requires a datearg instead of a DEC field. It is obvious, that a correct conversion is not possible without specifying the time additionally.

How am I able to convert a timestamp into DATE and TIME fields?

Thanks and regards,

Ulf