DSXchange

I have in my input fields such as Update Date and Time. I would like to add 6 hrs 30 min to that to get a new date and time. How to do the transformation.
Thanks.

Convert dates to Julian dates. Convert times to seconds from midnight. Do the arithmetic. Convert back to date/time/timestamp.

Sometimes Ray isn't too gentle with simple questions. You should really read the Parallel Job Developer Guide. But in this as in many instances the answers are not particularly apparent. Try page 606 under date and time functions. Convert 6 hours 30 min to seconds and use

TimestampFromSecondsSince function

Returns the timestamp from the number of seconds from the base timestamp

args: seconds (dfloat), [base timestamp]
output: timestamp

Hi,
Create a routine and call that to do the caluculation and change into required format.