Correct, I don't need the extra Iconv, But the Int(time()) should be added to remove any fractions.
ToDaysDate =(Int(Iconv('01:20:00',"MTS")) + ((Date() +1)*86400 )) - (Int(Time()) + (Date()*86400 ))
Search found 3 matches
- Tue Jan 30, 2007 10:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date subtraction into seconds
- Replies: 7
- Views: 1331
- Tue Jan 30, 2007 9:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date subtraction into seconds
- Replies: 7
- Views: 1331
- Tue Jan 30, 2007 8:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date subtraction into seconds
- Replies: 7
- Views: 1331
Date subtraction into seconds
I was wondering if anyone has some experience with getting the sysdate out of datstage ,Timedate() function, and then subtracting the two dates to get the total seconds between the 2 dates. Something like this Seconds_between =( Iconv('01:20:00',"MTS") + (Date() +1 ) - Iconv(TimeDate(),"MTS"@VM"D DM...