topic Re: time stamp in Application Development and Automation Discussions

time stamp

Former Member — Tue, 07 Feb 2006 17:42:34 GMT

hi,

is there a sy- field to get the timstamp(date+time).

Re: time stamp

Former Member — Tue, 07 Feb 2006 17:48:13 GMT

SY-TSTLO

Message was edited by: chandrasekhar jagarlamudi

Re: time stamp

former_member181966 — Tue, 07 Feb 2006 17:49:40 GMT

You can concatenate Sy-uzeit and Sy-datum ...

Also check out Sy-TZONE, Sy-DAYST ,Sy-DATLO

Sy-TIMLO,Sy-ZONLO.

There`s No field ( SY-TSTLO ) .. 4.7

I code the Field and also check it in SYST ...

USE the FM "CACS_DATE_GET_TIMESTAMP"

BWFIT_UPDATE_TIMESTAMPS

BWOMT_UPDATE_TIMESTAMPS

CACS_DATE_GET_TIMESTAMP

CFM_TR_BIW_UPDATE_TIMESTAMPS

FRE_CONVERT_DATE_TO_TIMESTMP Convert Date to Timestamp

PPELIHDR_UPDATE_TIMESTAMP

Thanks

Message was edited by: Saquib Khan

Re: time stamp

Former Member — Tue, 07 Feb 2006 17:53:26 GMT

hi,

there is no such field in syst table.

Re: time stamp

Former Member — Tue, 07 Feb 2006 17:57:24 GMT

How did u check out in SYST , it is a structure

u can try like this...

DATA: l_datum LIKE sy-datum, " Date

l_uzeit TYPE t, " Time

l_ctime LIKE sy-uzeit, " Current time

l_tstmp TYPE timestamp, " Time Stamp

CONVERT DATE l_datum

TIME l_ctime

INTO TIME STAMP l_tstmp TIME ZONE sy-zonlo.

Message was edited by: chandrasekhar jagarlamudi

Re: time stamp

suresh_datti — Tue, 07 Feb 2006 18:08:15 GMT

Hi,

You can try this if u hate to concatenate sy-datum & sy-uzeit..


report  zptest21                                .



data:
  s_tst type timestamp,
  l_tst type timestampl,
  tzone type timezone.

get time stamp field s_tst.    "short form
get time stamp field l_tst.    "long form
tzone = 'UTC   '.                   "time zone

write: / s_tst time zone tzone,
       / l_tst time zone tzone.

Regards,

Suresh Datti

Re: time stamp

Former Member — Tue, 07 Feb 2006 18:56:59 GMT

thanks.

my task was to subtract x number of minutes

from sy-uzeit by still keeping the correct date.

thanks

Re: time stamp

Former Member — Tue, 07 Feb 2006 19:03:01 GMT

and for that i was doing like:

v_t = sy-uzeit - x.

if v_t gt sy-uzeit.

v_d = sy-datum + 1.

endif.

select * from x

where date eq v_d

and time ge v_t.

***

and i wanted to eliminate this if i had a better option...

Re: time stamp

Former Member — Tue, 07 Feb 2006 19:08:07 GMT

as X is in minutes , ucannot directly subtract it from sy-uzeit , convert it to seconds and subtract

<b>x = x * 60.</b>
v_t = sy-uzeit - x.
if v_t gt sy-uzeit.
v_d = sy-datum + 1.
endif.