Hi All,
when i'm trying to convert epoch sec to date, its returning a non existing date. Did anyone face this challenge before?
q = load "Opportunities";
q = group q by all;
q = foreach q generate 1533254400000 as 'max', 0 as 'min';
q= foreach q generate toDate(max) as 'Max', toDate('min') as 'Min';
expected was to be Max as 8/3/2018 and Min as 1/1/1970
results which i'm getting is Max as 50556-11-24 00:00:00 and Min as 1970-01-01 00:00:00
