topic Re: Comparing two timestamps in Application Development and Automation Discussions

Comparing two timestamps

Former Member — Tue, 15 Jul 2008 06:08:28 GMT

How can we compare two time stamps ???

I tried using GE operator but it is not comparing it correctly. It is comparing it in numerical manner.

Please give the appropriate solution .

Re: Comparing two timestamps

Former Member — Tue, 15 Jul 2008 06:23:13 GMT

Hi,

TIMESTAMP is stored in the database in the UTC time zone. Time stamp values in the database are therefore independent of the time zone of the application that generated the value, and independent of the database instance. This means that you can compare time stamp values across different time zones.

TIMESTAMP data is represented as an object by using the class java.sql.Timestamp.

For further details,

check the source link [http://help.sap.com/saphelp_webas630/helpdata/en/6c/7784ac804be2419f957e8434be6a07/content.htm]

regards,

anirban

Re: Comparing two timestamps

Former Member — Tue, 15 Jul 2008 06:26:14 GMT

Hi Shreya,

Check out this link, which have comparision an also conversion of timestamps:

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

Hope this helps you.

Regards,

Chandra Sekhar

Re: Comparing two timestamps

Former Member — Tue, 15 Jul 2008 06:28:37 GMT

Hi,

Use the COMPARE method in the class CL_ABAP_TSTMP which is the optimal way.

CALL METHOD cl_abap_tstmp=>compare

EXPORTING

tstmp1 = timestamp1

tstmp2 = timestamp2

receiving

comp = result. " Result: Smaller (-1), Equal (0), Greater (1)

Cheers

Kothand

Re: Comparing two timestamps

Former Member — Tue, 15 Jul 2008 06:28:47 GMT

Use the COMPARE method of the class:

CL_ABAP_TSTMP.

TRY.

CALL METHOD cl_abap_tstmp=>compare

EXPORTING

tstmp1 =

tstmp2 =

receiving

comp =

CATCH cx_parameter_invalid_type .

CATCH cx_parameter_invalid_range .

ENDTRY.

Regards

Kannaiah

Re: Comparing two timestamps

Former Member — Tue, 15 Jul 2008 06:29:29 GMT

hi,

You can use CL_ABAP_TSTMP Class for the purpose.

Plz Refer to this link.

http://www.thaiabap.com/index.php?view=article&catid=47%3As&id=2614%3AABENNEWS-620-CLASSES.HTM&option=com_content&Itemid=3

Regards

Sumit Agarwal