int DiffDate(String yyyymmdd1, String yyyymmdd2)
date string in "yyyymmdd" format
(date1-date2) in days, can be negative
414243444546474849505152535455565758
Tuple t4 = TupleFactory.getInstance().newTuple(2); t4.set(0, "20090608"); t4.set(1, null); DiffDate func = new DiffDate(); Integer r = func.exec(t1); assertTrue(r==-23); r = func.exec(t2); assertTrue(r==426); r = func.exec(t3); assertTrue(r==null); r = func.exec(t4); assertTrue(r==null); }