subtract two dates

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Javieregh
Participant
Posts: 25
Joined: Mon Apr 16, 2007 10:35 am
Location: JavierGH

subtract two dates

Post by Javieregh »

I need to converter this sql calculation to Datastage, both dates are timestamp

result = floor (date1 - date2)

I have the following message

Error in output column derivation expression for column result in link DSLink129. Invalid conversion requested from a timestamp to a dfloat.

Thanks
Javier
Consultant in DTS
Top
XRAY
Participant
Posts: 33
Joined: Mon Apr 03, 2006 12:09 am

Post by XRAY »

What is being expected ?

There are some functions in the parallel developer guide on timestamp/date function.You may need to convert the dates into numbers then do the subtraction. Lastly, convert the result back to date....

But is that what you want ?
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

What data type is the result of subtracting two timestamps?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”