Search found 3 matches

by rayx0063
Tue Jan 30, 2007 10:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date subtraction into seconds
Replies: 7
Views: 1326

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 ))
by rayx0063
Tue Jan 30, 2007 9:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date subtraction into seconds
Replies: 7
Views: 1326

Thanks, i was just over looking a couple of things... I should look like this.

SecondsBetween =(Iconv('01:20:00',"MTS") + (Iconv( (Date() +1),"D DMY")*86400 )) - (Int(Time()) + (Iconv(Date(),"D DMY")*86400 ))
by rayx0063
Tue Jan 30, 2007 8:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date subtraction into seconds
Replies: 7
Views: 1326

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...