topic Re: timestamp to date conversion in Application Development and Automation Discussions

timestamp to date conversion

Former Member — Mon, 28 Oct 2013 02:28:22 GMT

I have got to get a local date from time stamp. Time stamp is of server time. And I have time zone off set. for example

20,130,927,183,711 -04:00

20,130,905,200,845 +02:00

I need to use the time zone offset to get the local date.

I was hoping I will be able to use

CONVERT TIME STAMP my_TSTMP TIME ZONE
tzone INTO DATE calday .

but tzone is expected in the formate of UTC-1 or UTC+2 as such. What will be the best option to get the local date from the information I have in hand. Any suggestion will be very much appreciate.

Re: timestamp to date conversion

Former Member — Mon, 28 Oct 2013 03:21:29 GMT

This message was moderated.

Re: timestamp to date conversion

sivaganesh_krishnan — Mon, 28 Oct 2013 04:19:41 GMT

Hi Sophie,

Instead of passing the time of different places directly , just refer table TTZZ . This table contains all the timezone , select the zone for which ur coding and pass it like this.

DATA:

s_tst LIKE tzonref-tstamps,
l_tst LIKE tzonref-tstampl,
tzone LIKE tzonref-tzone,
d TYPE D ,
t TYPE T .

GET TIME STAMP FIELD s_tst.         "Short form
GET TIME STAMP FIELD l_tst.         "Long form
tzone = 'ALA '.                                   "Specify the time zone here.. refer TTZZ table

CONVERT TIME STAMP l_tst TIME ZONE tzone INTO
        DATE d TIME t.

"timestamps - short and long
WRITE: / s_tst TIME ZONE tzone,
              / l_tst TIME ZONE tzone.

WRITE:/ 'After conversion'.

WRITE:/ d,      " 12/24/1997

    /, (8) t.      " 23:55:00

Hope this Helps

Regards,

Sivaganesh

Re: timestamp to date conversion

anshu_lilhori — Mon, 28 Oct 2013 05:13:40 GMT

Hi,

You may try to use the following function module;

CONV_UTIL_ADD_DATE_AND_TIME

Hope that helps.

Regards,

Re: timestamp to date conversion

Former Member — Mon, 28 Oct 2013 05:37:08 GMT

HI,

DATA : v_timestamp TYPE timestampl,

output TYPE string.

GET TIME STAMP FIELD v_timestamp.

WRITE : v_timestamp.

output = |{ v_timestamp TIMESTAMP = ISO }|."TIMEZONE = 'UTC ' }|.

WRITE / output.

OR this should work for you.

DATA : v_timestamp TYPE timestampl,

v_timestamp1 TYPE timestampl,

output TYPE string,

date TYPE datum,

time TYPE tims.

DATA : time_zone TYPE tzonref-tzone value 'INDIA'.

GET TIME STAMP FIELD v_timestamp.

WRITE : v_timestamp.

CONVERT TIME STAMP v_timestamp TIME ZONE time_zone INTO date date Time time.

write :date DD/MM/YYYY .

WRITE : time.

Thanks & Regards

Priyesh Shah

Message was edited by: Priyesh Shah

Re: timestamp to date conversion

rosenberg_eitan — Mon, 28 Oct 2013 06:39:15 GMT

Hi,

Try this:

Regards.

REPORT y_r_eitan_test_09_03 .

*----------------------------------------------------------------------*

SELECTION-SCREEN BEGIN OF BLOCK block02 WITH FRAME .

PARAMETERS: p_date_f TYPE sydatum OBLIGATORY DEFAULT sy-datum .

PARAMETERS: p_time_f TYPE syuzeit OBLIGATORY DEFAULT sy-uzeit .

SELECTION-SCREEN SKIP .

PARAMETERS: p_zone_f TYPE ttzz-tzone OBLIGATORY DEFAULT sy-zonlo .

PARAMETERS: p_zone_t TYPE ttzz-tzone OBLIGATORY DEFAULT 'JAPAN' .

SELECTION-SCREEN END OF BLOCK block02 .

*----------------------------------------------------------------------*

AT SELECTION-SCREEN .

PERFORM at_selection_screen_input .

*----------------------------------------------------------------------*

FORM at_selection_screen_input .

DATA: stamp_1 TYPE timestamp .

CONVERT DATE p_date_f TIME p_time_f

    INTO TIME STAMP stamp_1 TIME ZONE p_zone_f .

IF sy-subrc NE 0 .

    MESSAGE e212(rd) .

ENDIF .

DATA: dst TYPE c LENGTH 1 .

DATA: datum TYPE sydatum .

DATA: uzeit TYPE syuzeit .

CONVERT TIME STAMP stamp_1 TIME ZONE p_zone_t

    INTO DATE datum TIME uzeit DAYLIGHT SAVING TIME dst.

MESSAGE s000(oo) WITH 'Time at' p_zone_t datum uzeit .

ENDFORM .                    "at_selection_screen_input

*----------------------------------------------------------------------*

Re: timestamp to date conversion

Former Member — Fri, 01 Nov 2013 08:55:50 GMT

Hi Sophie,

You can try this:

cl_abap_tstmp=>systemtstmp_utc2syst( EXPORTING utc_tstmp = lv_utc_timestamp IMPORTING syst_date = lv_system_date " System Date syst_time = lv_system_time " System Time ).

Regards,

Ashish Kumar

Re: timestamp to date conversion

Former Member — Fri, 01 Nov 2013 11:50:07 GMT

HI,

Try This..

CONVERT TIME STAMP my_TSTMP TIME ZONE ' UTC '
INTO DATE date TIME time.

Regards,

Charan M.

Re: timestamp to date conversion

former_member192854 — Fri, 01 Nov 2013 12:05:05 GMT

I should use your solution,and for tzone I should use sy-zynlo.

Best,

Sander

Re: timestamp to date conversion

Former Member — Fri, 01 Nov 2013 18:56:59 GMT

Hi,

Charan has the right idea. You need to convert the timestamp you have (e.g. 20,130,927,183,711 -04:00) to UTC and then convert that to the local time zone.

If your report is dependent upon a plant code you may not be able to us sy_zynlo. If this is the case you may need to create a separate configuration table with plant codes and time zones.

Regards,

Steve

Re: timestamp to date conversion

Former Member — Thu, 05 Dec 2013 14:06:11 GMT

Hi Guys,

Thanks for all your replies. My problem was I do not have time zone in the format required. What I ended up doing was, I first offset the timestamp with the time zone information I had.

for example for this record =>

20,130,927,183,711

-04:00

I subtract 4 hours from the time stamp. And convert the resulting timestamp (which is now a local date and time ) into date with 'UTC' as a time zone. It gives me a local date.