topic Re: Function Module to get the TIMESTAMP in Application Development and Automation Discussions

Function Module to get the TIMESTAMP

naveen_inuganti2 — Wed, 13 May 2009 11:08:51 GMT

Hi,

Is there any function module to get the TIMESTAMP as Outout , if i give input Time and Date.

Or,

If I go for the concatenate statement.. Do I need to concate the commas in to the target field?

Because,

I am not getting the proper result with this concatenate statement where I concatenated the YYYYMMDDHHMMSS in to the DECIMAL 15 Variable.

Thanks,

Naveen Inuganti.

Re: Function Module to get the TIMESTAMP

Former Member — Wed, 13 May 2009 11:15:52 GMT

Hi Naveen,

Check with below

for Date + time -- > time stamp

ABI_TIMESTAMP_CONVERT_INTO

for time stamp ---> date + time

ABI_TIMESTAMP_CONVERT_FROM

Thanks!

Re: Function Module to get the TIMESTAMP

former_member188829 — Wed, 13 May 2009 11:16:02 GMT

Hi Naveen,

Try this function module.

LTRM_TIMESTAMP_CONVERT_INTO

Re: Function Module to get the TIMESTAMP

GauthamV — Wed, 13 May 2009 11:18:14 GMT

Check this.

LTRM_TIMESTAMP_CONVERT_INTO

RKE_TIMESTAMP_CONVERT_INPUT

Re: Function Module to get the TIMESTAMP

Former Member — Wed, 13 May 2009 11:28:49 GMT

Hi Naveen,

LTRM_TIMESTAMP_CONVERT_INTO

OII_CALC_DIFF_BT_TIMESTAMPS try this FM

Use FM CCU_TIMESTAMP_DIFFERENCE

It gives you the difference between two timestamps in seconds.

which you can divide by 3600 to get hours.

G_BIW_CONVERT_INTO_TIMESTAMP

Regards,

Venkat M.

Re: Function Module to get the TIMESTAMP

naveen_inuganti2 — Wed, 13 May 2009 11:36:30 GMT

Thanks for your inputs.

There are more than one record for same date in one of my tables,

But there is no date field in that table. There is a TIMESTAMP.

And my report selection screen can have DATE field only.

So based on that date I need to fetch all the records in that table.

As we know before that select I need to modify selection screen DATE as the TIMESTAMP.

And that should fetch all records...as there is no time restriction.

Finally we need to create Ranges where lower limit with DAY START TIME

and upper limit with DAY END TIME.

I tried to modify the SY_UZEIT before passing to above function modules.

as SY-UZEIT = 000000 for lower limit.

as SY_UZEIT = 125959 for upper limit.

Its not giving the proper time stamp, what would you suggest.

Thanks,

Naveen.I

Re: Function Module to get the TIMESTAMP

Former Member — Wed, 13 May 2009 11:38:55 GMT

ABI_TIMESTAMP_CONVERT_INTO can be used

Regards,

Re: Function Module to get the TIMESTAMP

naveen_inuganti2 — Wed, 13 May 2009 11:43:50 GMT

No Srinivas,

Its Not working,

data: lv_timestamp type TZNTSTMPS,
      lv_date type SY-DATLO,
      lv_time type SY-TIMLO.

sy-uzeit = 000000.

call function 'ABI_TIMESTAMP_CONVERT_INTO'
  exporting
    iv_date                = sy-datum
    iv_time                = sy-uzeit
 IMPORTING
   EV_TIMESTAMP           = lv_timestamp
* EXCEPTIONS
*   CONVERSION_ERROR       = 1
*   OTHERS                 = 2
          .
if sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
endif.

write:/ lv_timestamp.

Output:

> 20,090,512,220,000

But it should be:

> 20,090,513,000,000

--Naveen

Re: Function Module to get the TIMESTAMP

Former Member — Wed, 13 May 2009 11:44:31 GMT

Hi use

IB_CONVERT_INTO_TIMESTAMP' or IB_CONVERT_FROM_TIMESTAMP'

Example:

* Declaring the work variables.......................
DATA :
  timestamp like TZONREF-TSTAMPS,
  time      like sy-uzeit,
  date      like sy-datum.

* The following function module is used to convert the
* time and date into GMT timestamp

CALL FUNCTION 'IB_CONVERT_INTO_TIMESTAMP'
  EXPORTING
    i_datlo           = sy-datum
    i_timlo           = sy-uzeit
    I_TZONE           = 'INDIA'
 IMPORTING
   E_TIMESTAMP       = timestamp.

* The following function module is used to convert the
* above obtained timestamp to PST time zone date and time.

CALL FUNCTION 'IB_CONVERT_FROM_TIMESTAMP'
  EXPORTING
    i_timestamp       = timestamp
    I_TZONE           = 'PST'
 IMPORTING
    E_DATLO           = date
    E_TIMLO           = time.

write :/ 'Date and Time at PST zone is ',date, time.

Re: Function Module to get the TIMESTAMP

Former Member — Wed, 13 May 2009 12:15:59 GMT

Hi,

Try using this instead of a function module

Convert dates to timestamp

CONVERT DATE sy-datum TIME sy-uzeit

INTO TIME STAMP g_timestmp1 TIME ZONE sy-zonlo.

Regards,

Hema.