Skip to Content

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

Date Format Issue

Hi all,

There is a FM to convert sao format date to oracle format date?

Like: 20090521

To: 21-MAY-2009

Or, help me to made this update works:

vl_date = sy-datum.

TRY.

EXEC SQL.

UPDATE SAP_MUDANCA_MARGEM@DBLINK_63

SET SM_FLAG_LEITURA =: vl_err

SM_DATA_SAP =: TO_DATE(vl_date, 'YYYYMMDD')

WHERE SM_ID_SM =: wl_trlogic-chave

ENDEXEC.

CATCH cx_sy_native_sql_error INTO vl_excref.

vl_error_text = vl_excref->get_text( ).

MESSAGE vl_error_text TYPE 'I'.

ENDTRY.

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