Page 1 of 1

How to make operations on date fields

Posted: Wed Jan 16, 2008 5:06 pm
by jseclen
Hi Forum,

I'm working in Data Stage Enterprise 7.5.2 in AIX server 5.3, and i need to obtain the difference between two dates, in server version i use iconv for both fields and obtain the result, but in parallel i can't ..

Anybody has an answer ??

Is there another choice to obtain this result??

Thanks

Posted: Wed Jan 16, 2008 5:50 pm
by ray.wurlod
In Appendix A of the Parallel Job Developers Guide is a list of all the Transformer stage functions.

My first guess would be to use DaysSinceFromDate(). In a Modify stage this function is called days_since_from_date()

My second guess would be to apply JulianDayFromDate() to both dates and subtract. In a Modify stage arithmetic is not possible.