Skip to Content
avatar image
Former Member

COEP timestamp conversion in HANA

Hi,

I am replicating COEP table in HANA. I need to create an additional column for the table which gives the posting date. COEP table has TIMESTAMP column, however the data is stored in DEC 16 format.

I was able to find an ABAP function module / logic to covert it into SQL date.

Please let me know if this can be done in native HANA.

Thanks,

Aamod.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 28, 2015 at 08:58 AM

    Hi Aamod,

    to get the 'DD.MM.YYYY' format below is the script.

    SELECT TO_CHAR(TO_DATE(:COEP_FIELD), 'DD.MM.YYYY') INTO IS_VALID FROM dummy ;

    change the format according to your requirement.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Lars Breddemann

      Hi Lars,

      Please let me know if there is a way to convert the COEP timestamp in HANA table generated column.

      Thanks,

      Aamod.