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.
Date Time manipulation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
TimestampFromSecondsSince function
Returns the timestamp from the number of seconds from the base timestamp
args: seconds (dfloat), [base timestamp]
output: timestamp
Michael Favero
2852 Humboldt Ave So
Minneapolis, MN 55408
2852 Humboldt Ave So
Minneapolis, MN 55408
-
- Participant
- Posts: 111
- Joined: Thu Jun 01, 2006 5:12 am
- Location: Detroit