Time Stamp

[Former Member]

Dear All

I am taking date and time from user in

YYYYDDMM format for date and

HHMMSS format for time.

I need to compare this input with SENDTIME field in SXMSPMAST table which is in following format

UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)

Can anyone tell me how can i compare my inputs with this field.

[Former Member]

hi first concatenate these two and send it to another char field ...then compare there two

[Former Member]

hi,

Use offset and compare the value ...

PARAMETERS : p_date   LIKE sy-datum,
             p_uzeit  LIKE sy-uzeit.

DATA : v_compare LIKE sxmspmast-sendtimest,
       v_char(15),
       v_date LIKE sy-datum,
       v_time LIKE sy-uzeit.

v_char = v_compare.
v_date = v_char+0(8).
v_time = v_char+8(6).

IF v_date = p_date OR
   v_time = p_uzeit.
*** Do something
ENDIF.
 

Regards,

Santosh

[kiran_k8]

Sourabh,

Check the below given link

http://www.sapnet.ru/abap_docu/ABENTIME-STAMP-GENERAL.htm

K.Kiran.