Convert SAP Timestamp into UTC

[somenathroy]

Hi All,

I am extracting data from a SAP table, RSICCONT. I need to covert values of TIMESTAMP field of this table into UTC.

Any idea would be highly appreciated.

Thanks,

Somnath

[Anonymous]

Did you check this?

how to convert a local time to utc time when I have the time zone?

[somenathroy]

Sorry missed to mention. Indian Standard Time can be considered.

[Anonymous]

Check the thread which I already shared with you

[tresesco]

Indian standard Time is 5.5 hrs ahead of UTC, so you can simply subtract that (1/24*5.5), like

(your timestamp - 1/24*5.5)

[somenathroy]

For your reference TIMESTAMP field contains values like :

20160112071928

20160112071735

20160112071721

20160112071305

20160112071054

20160112070908

20160112070826

20160112070710

[PrashantSangle]

Hi,

try below code

=timestamp(num(timestamp#(20160112071928,'YYYYMMDDhhmmss'))-1/24*5.5)

Syntax:

=timestamp(num(timestamp#(YourDateField,'YYYYMMDDhhmmss'))-1/24*5.5)

Regards

[Anonymous]

last 6 digit are time stamp??

use mid() like:

mid(20160112071928,9,6) which would return 071928 & use Time Functions

[suniljain]

E.g :

Date(Date(20160112070710,'YYYYMMDDhhmmss'),'DD/MM/YYYY')