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

[HirisH_V7]

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