topic Re: Convert SAP Timestamp into UTC in QlikView

Convert SAP Timestamp into UTC

somenathroy — Tue, 12 Jan 2016 10:26:40 GMT

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

Re: Convert SAP Timestamp into UTC

Anonymous — Tue, 12 Jan 2016 10:29:51 GMT

Did you check this?

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

Re: Convert SAP Timestamp into UTC

somenathroy — Tue, 12 Jan 2016 10:46:57 GMT

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

Re: Convert SAP Timestamp into UTC

Anonymous — Tue, 12 Jan 2016 10:50:55 GMT

Check the thread which I already shared with you

Re: Convert SAP Timestamp into UTC

tresB — Tue, 12 Jan 2016 10:53:08 GMT

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)

Re: Convert SAP Timestamp into UTC

somenathroy — Tue, 12 Jan 2016 10:58:29 GMT

For your reference TIMESTAMP field contains values like :

20160112071928

20160112071735

20160112071721

20160112071305

20160112071054

20160112070908

20160112070826

20160112070710

Re: Convert SAP Timestamp into UTC

PrashantSangle — Tue, 12 Jan 2016 11:06:06 GMT

Hi,

try below code

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

Syntax:

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

Regards

Re: Convert SAP Timestamp into UTC

Anonymous — Tue, 12 Jan 2016 11:06:22 GMT

last 6 digit are time stamp??

use mid() like:

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

Re: Convert SAP Timestamp into UTC

suniljain — Wed, 17 Feb 2016 17:38:52 GMT

E.g :

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