Subtract 1 second

Jim Grover · Post by **Jim Grover** » Mon Jul 17, 2006 10:37 pm

I need to subtract one second from the current time in a parallel job; does anyone have an approach or an example?

much appreciated

ArndW · Post by **ArndW** » Tue Jul 18, 2006 1:07 am

Hello Jim,

PX has a number of builtin functions for handling time and timestamps. If you have a timestamp value, you can use the function TimestampFromSecondsSince to subtract one second from a timestamp value.

kumar_s · Post by **kumar_s** » Tue Jul 18, 2006 3:14 am

Basically, you need to convert into the internal format of datastag (using TimestampFromSecondsSince or TimestampFromDateTime or TimeFromMidnightSeconds or SecondsSinceFromTimestamp.... ) and subtract 1 second from it and convert it back to the required format.

Jim Grover · Post by **Jim Grover** » Tue Jul 18, 2006 9:17 am

Thank you both for the help; I had played with TimestampFromSecondsSince but was not using it in the correct way. I've now got it working.

mjmagalsky · Post by **mjmagalsky** » Wed Apr 18, 2007 4:28 pm

I have a similar need but I need to subtract one millisecond from a timestamp. However, TimestampFromSecondsSince is apparently only partially-compatible with subsecond times. For example, this derivation:
TimestampFromSecondsSince(-.001, FunneledData.TRANSACTION_TIME)
yields this result:
Input :2007-04-11 15:42:28.113000
Output:2007-04-11 15:42:27.999000

It appears to round down to the full second and then subtract the partial second. Any input or alternative suggestions are appreciated.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 18, 2007 4:36 pm

Welcome aboard. :D

Etiquette Note
We don't hijack threads. This is not the identical problem, and will have a different solution, so you must start a new thread.

DSXchange

Subtract 1 second

Subtract 1 second

Subtracting a millisecond from a Timestamp