I have an API and I need to dynamically generate a UNIX timestamp in seconds by taking the current time and subtracting an amount of time from it so I can use it in a query parameter.
I’m not sure how to see what these produce, but my guess is none of them are outputting seconds.
You can easily see what any of these produce, when you create a set value step and bind any of these as a value for it, then run the server action. Don't forget to enable output so you can see the value.
TIMESTAMP returns unix timestamp.
In your case you can use NOW to get the current date, subtract 1 hour and convert to timestamp:
