Reduce data on epoch/java unix time

Fri, 23 Apr 2010 10:16:32 GMT

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.

topic Reduce data on epoch/java unix time in QlikView