Skip to Content
0

Convert varchar format to datetime format issue

Jun 05, 2017 at 06:52 AM

60

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hello Sudhir,

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

Let me know!

Share
10 |10000 characters needed characters left characters exceeded