Convert millseconds into Unix TimeStamp

m2014227 — Thu, 21 Jul 2016 20:18:04 GMT

Hi experts, I've the following field: 1388481000000 as the number of milliseconds elapsed from the Unix Epoch (1970-01-01 UTC) How can I convert to Unix TimeStamp? I'm trying to use ToUnixTime(1388481000000,'dd/MM/yyyyHH:mm:ss','GMT') but it gives me error... How can I convert into Unix Timestamp? Many thanks!

Re: Convert millseconds into Unix TimeStamp

ssanku — Mon, 19 Aug 2019 08:18:02 GMT

Hi @Johnny Fugers,

Input file data as: dataset.csv

This gives answer in CET

563355,1388481000000

563356,1388481000000

a = load '/tmp/dataset.csv' using PigStorage(',') as (id:chararray, at:chararray);

b = foreach a generate id, ToString( ToDate( (long)at), 'yyyy-MM-dd hh:ss:mm' );

c = group b by id;

dump c;

This is how it works in GMT:

a = load '/tmp/dataset.csv' using PigStorage(',') as (id:chararray, at:chararray);

b = foreach a generate id, ToDate(ToString(ToDate((long) at), 'yyyy-MM-dd hh:ss:mm'), 'yyyy-MM-dd hh:ss:mm', 'GMT');

c = group b by id;

dump c;

Hope that helps,

Thanks,

Sujitha

question Convert millseconds into Unix TimeStamp in Archives of Support Questions (Read Only)

Convert millseconds into Unix TimeStamp

Re: Convert millseconds into Unix TimeStamp