topic Re: Date Format Issue in Application Development and Automation Discussions

Date Format Issue

Former Member — Thu, 21 May 2009 13:04:03 GMT

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.

Re: Date Format Issue

former_member188829 — Thu, 21 May 2009 13:06:05 GMT

Hi,

Try this function module.

CONVERSION_EXIT_LDATE_OUTPUT

DATA:input TYPE sy-datum VALUE '20090521',
     output TYPE string.

START-OF-SELECTION.
  CALL FUNCTION 'CONVERSION_EXIT_LDATE_OUTPUT'
    EXPORTING
      input  = input
    IMPORTING
      output = output.

  WRITE output.

Re: Date Format Issue

gautam_totekar — Thu, 21 May 2009 13:16:05 GMT

Try Moving it to character field variable by using offset for date month and year . then concatenate it using '-'

Re: Date Format Issue

former_member188829 — Thu, 21 May 2009 13:37:31 GMT

Hi,

DATA:input TYPE sy-datum VALUE '20090521',
     output TYPE string,
     month_names TYPE t247.

START-OF-SELECTION.

SELECT SINGLE * FROM t247 INTO month_names WHERE spras = sy-langu
                                           AND mnr = input+4(2).
  IF sy-subrc EQ 0.
   CONCATENATE input+6(2) '-' month_names-ltx '-' input+0(4) INTO output.
  ENDIF.

  WRITE output.

Re: Date Format Issue

Former Member — Thu, 21 May 2009 13:41:00 GMT

Hi,

Try the following code.

DATA: X_MONTH(12).

START-OF-SELECTION.

CALL FUNCTION 'CONVERSION_EXIT_LDATE_OUTPUT'

EXPORTING

input = sy-datum

IMPORTING

output = x_month.

concatenate x_month(2) '-' x_month4(3) '-' x_month8(4) into x_month.

WRITE:/ x_month.

Thanks

Ramana

Re: Date Format Issue

Former Member — Thu, 21 May 2009 17:24:41 GMT

I fixed my exeq sql. Thx all anyway.