Skip to Content
0
Jul 24, 2017 at 03:29 PM

Local Date and Time to local Timestamp

679 Views

Hi,

I wanted to convert factory start date and time of a task into local factory timestamp.

I tried below, but it outputs UTC timestamp. But I need local timestamp.

convert date lv_local_start_date time lv_local_start_time into time stamp LOC_ST_TMSTMP time zone <fs_wa_plant>-tzone.


TZONE comes from plant attribute of factory calendar. For example for switzerland it is 'CET'.

But below works somehow, .....UTC Timestamp to local date and time.

CONVERT TIME STAMP lv_start_utc_tstmp TIME ZONE <fs_wa_plant>-tzone INTO DATE lv_local_start_date TIME lv_local_start_time.

I don't want direct UTC timestamp to local timestamp though. I am deriving local date and time from UTC timestamp, converting to factory date and time and then that converting to local factory timestamp.

A direct conversion from UTC timestamp to factory timestamp could work though.

Regards,

Cleo