Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

to_date function in bods is giving wrong results.

Hi ,

While I'm trying to convert the below string into date time its giving wrong results for the year 2015

But till 2014 it was working fine can you please help me with this code.

     $G_Test = '01-JAN-15 17:30:35';

    $G_DATE =to_char( $G_Test, 'DD-MON-YYYY hh24:mi:ss');

    print('$G_DATE :                [$G_DATE]') ;

Result is 1915.01.01 17:30:35 but the expected result is 2015.01.01 17:30:35 till 2014 it was working fine but after this year is converting to 19.

Former Member
Former Member replied

Hello Venkata S,

Please reference the following post:

IMPORTANT: 2015 date conversion issue_all versions of SAP Data Services


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question