Skip to Content
avatar image
Former Member

Convert varchar format to datetime format issue

Hi All,

Please can someone help me on converting Varchar format of value into date time format in bods.

Source is C4C which contains a column with the varchar format value like '20160406122033' and i want to convert this varchar format value into datetime format and then load into HANA.

Appreciate for your quick response.!

Thanks & Regards,

Sudheer Reddy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 13, 2017 at 02:07 PM

    Hello Sudhir,

    Try to_date('20160406122033','yyyymmddhhmiss');

    Let me know!

    Add comment
    10|10000 characters needed characters exceeded