how to add two input time columns

[arasan]

how to add 2 input time columns

for example:

input A ----- 200408160545
YYMMDDHHSS (YEAR/MONTH/HOUR/SEC)
+
input B ------ 0030(HOUR/SS)

OUTPUT SHOULD BE IN THS FORMAT: 200408160615

[ArndW]

The DataStage PX developer's guide lists the date/time functions on pages B-1 and B-2; if you convert you string to a timestamp you can use those functions. Another way would be to do your own date math; convert the characters yourself into numbers representing yyyy, mm, dd and hh:mm:ss and do the math, then use the builtin functions to convert that to your requested output format.

In this case it might be best to convert the string date into a julian date which makes maths easier, then convert that julian date to a display date.

[ray.wurlod]

You're almost certainly going to need something custom here, because there's nothing out of the box to add date/time data.

Be aware that you need to handle situations like the result not being on the same day as the original date/time, and possibly a negative time to add.

[Sunshine2323]

Hi arasan,

TimestampFromSecondsSince(seconds,timestamp) Function

Use the StringToTimestamp(string,"%yyyy%mm%dd%hh%nn") function to convert the string to Timestamp

Convert the input B ------(HOUR/SS) into seconds
e.g. 1330 = (13*60*60+30) seconds
and then use the above function (TimestampFromSecondsSince) to add the seconds to the timestamp and you will get the desired result.

Hope this helps