Calculation for Timestamp

ysweec · Post by **ysweec** » Tue Jul 13, 2004 11:18 pm

duration = (end_time - start_time) in hour , decimal(10,4)
availability = % of duration in 24 hour, decimal(5,2)

e.g
duration = (2004-07-09 15:33:35 -2004-07-09 15:28:35) * 24
availability = (2004-07-09 15:33:35 -2004-07-09 15:28:35) /24 * 100

Can this calculation be done in DS?

rasi · Post by **rasi** » Wed Jul 14, 2004 12:29 am

Yes it is possible to do in DataStage. It is just a matter of passing the parameter and using the correct conv functions to do. According to your parameter the conversion will change.

Cheers
Rasi