Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please let me know how can we convert SGT Timwstamp to UTC TimeStamp..
Eg: 2/27/2016 7:00:00 PM
Thanks
Lakshmana
Hi,
Try like this
=Timestamp(WIP_TIMESTAMP- 8/24, 'MM/DD/YYYY hh:mm:ss TT')
Regards,
Jagan.
ConvertToLocalTime( timestamp#('2/27/2016 7:00:00 PM', 'M/D/YYYY h:mm:ss tt') , 'UTC-8.00' )
I tried to implement as shown above,.
I am not getting any result... .. Its blank
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')
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
Try this expression
Timestamp(WIP_TIMESTAMP- 0.33333, 'DD/MM/YYYY hh:mm:ss TT')
this should work
Hi,
Try like this
=Timestamp(WIP_TIMESTAMP- 8/24, 'MM/DD/YYYY hh:mm:ss TT')
Regards,
Jagan.
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
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
];