Converting from SGT to UTC Timestamp

[lakshmanvepuri]

Hi,

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

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

Thanks

Lakshmana

[maxgro]

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

[Chanty4u]

chk dis

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

[lakshmanvepuri]

I tried to implement as shown above,.

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

[avinashelite]

try like this

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

or

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

[lakshmanvepuri]

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

[avinashelite]

Try this expression

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

this should work

[jagan · Accepted solution]

Hi,

Try like this

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

Regards,

Jagan.

[HirisH_V7]

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

[MayilVahanan]

HI

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

[

T

03/09/2016 10:00:00 AM

];