topic Converting from SGT to UTC Timestamp in QlikView

Converting from SGT to UTC Timestamp

lakshmanvepuri — Sat, 27 Feb 2016 11:45:34 GMT

Hi,

Please let me know how can we convert SGT Timwstamp to UTC TimeStamp..

Eg: 2/27/2016 7:00:00 PM

Thanks

Lakshmana

Re: Converting from SGT to UCT Timestamp

maxgro — Mon, 29 Feb 2016 21:07:05 GMT

ConvertToLocalTime( timestamp#('2/27/2016 7:00:00 PM', 'M/D/YYYY h:mm:ss tt') , 'UTC-8.00' )

Re: Converting from SGT to UCT Timestamp

Chanty4u — Tue, 01 Mar 2016 06:01:13 GMT

chk dis

http://www.worldtimebuddy.com/est-to-gmt-converter

Re: Converting from SGT to UCT Timestamp

lakshmanvepuri — Mon, 07 Mar 2016 03:43:08 GMT

I tried to implement as shown above,.

I am not getting any result... .. Its blank

Re: Converting from SGT to UCT Timestamp

avinashelite — Mon, 07 Mar 2016 08:17:11 GMT

try like this

Time(yourtimetime - time#(8,'h'), 'hh:mm:ss')

=Timestamp('3/12/2014 12:11:53 PM' - 0.33333, 'hh:mm:ss')

Re: Converting from SGT to UCT Timestamp

lakshmanvepuri — Wed, 09 Mar 2016 02:25:53 GMT

Hi Avinash,

I didn't the data as expected. Please find the code and the output.

left Keep(KL)

LOAD

ConvertToLocalTime(WIP_TIMESTAMP, 'UTC') AS UTC_Time,

ConvertToLocalTime(WIP_TIMESTAMP, 'UTC-8.00') AS UTC_Time1,

ConvertToLocalTime( Timestamp#(WIP_TIMESTAMP), 'UTC-8.00') AS UTC_Time2,

Time#(WIP_TIMESTAMP - Time#(8,'h'), 'hh:mm:ss') AS UTC_Time3,

Time(WIP_TIMESTAMP - Time#(8,'h'), 'hh:mm:ss') AS UTC_Time4,

Timestamp(WIP_TIMESTAMP - 0.33333, 'hh:mm:ss') AS UTC_Time5

Resident KL;

I want the Output as : 03/09/2016 02:00:00 AM

Thanks a lot

Re: Converting from SGT to UTC Timestamp

avinashelite — Wed, 09 Mar 2016 05:16:17 GMT

Try this expression

Timestamp(WIP_TIMESTAMP- 0.33333, 'DD/MM/YYYY hh:mm:ss TT')

this should work

Re: Converting from SGT to UTC Timestamp

jagan — Wed, 09 Mar 2016 05:35:25 GMT

Hi,

Try like this

=Timestamp(WIP_TIMESTAMP- 8/24, 'MM/DD/YYYY hh:mm:ss TT')

Regards,

Jagan.

Re: Converting from SGT to UTC Timestamp

HirisH_V7 — Wed, 09 Mar 2016 05:38:09 GMT

Hi,

Check this,

Data:
LOAD * ,
ConvertToLocalTime(Timestamp#(Time,'M/D/YYYY h:mm:ss tt'),'Singapore') as UTC1,
ConvertToLocalTime(Timestamp#(Time,'M/D/YYYY h:mm:ss tt'),'UTC+08:00') as UTC


INLINE [
    Time
    2/27/2016 7:00:00 PM
];

Both will give the same output,

Hope this helps,

PFA,

Hirish

Re: Converting from SGT to UTC Timestamp

MayilVahanan — Wed, 09 Mar 2016 05:39:14 GMT

Try like this

LOAD *, (Timestamp(Timestamp#(T ,'DD/MM/YYYY hh:mm:ss tt')-8/24, 'DD/MM/YYYY hh:mm:ss TT')) as T1, Timestamp(ConvertToLocalTime(Timestamp#(T,'D/M/YYYY h:mm:ss tt'),'UTC-08:00'),'DD/MM/YYYY hh:mm:ss TT') as T2 inline

[

03/09/2016 10:00:00 AM

];

Re: Converting from SGT to UCT Timestamp

HirisH_V7 — Wed, 09 Mar 2016 06:09:46 GMT

Hi ,

May be like this,

Data:
LOAD * ,
Timestamp(Timestamp#(Time,'DD/MM/YYYY h:mm:ss tt')-Time#('8:00:00','h:mm:ss'),'DD/MM/YYYY h:mm:ss tt') as UTC1
INLINE [
    Time


    03/09/2016 10:00:00 AM
    04/09/2016 09:00:00 AM
];

you can have eight hours difference,

HTH,

PFA

Hirish