Hello,
I'm extracting data from an oracle database which is using something called epoch time (java date format). Haven't come across this before.
Have been able to convert the strings to timestamps like this:
Let vBASE = num(makedate(01,01,1970));
date($(vBASE) + floor(TRANS_TIME/86400000.0416667)) as Date
where TRANS_TIME is the timestamp from the database.
Now I want to make a reduction on which data I extract but can't find a to do it. Tried with
where num(TRANS_TIME) > num(1240476720);
where year(timestamp($(vBASE) + (TRANS_TIME/86400000.0416667)))> 2010 ;
the string in the first clause is Fri, 23 Apr 2009 08:52:00 GMT which I get if i enter that date in http://www.epochconverter.com/
Any ideas?
Thanks.
