Definition and Usage
This command converts a timestamp value to a datetime format. It allows you to specify the time granularity (seconds, milliseconds, or microseconds) and choose whether to output the result as a text string or a datetime object.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Timestamp | Enter the timestamp to convert to datetime | - | Yes | Accepts numeric timestamp values |
Time granularity | Select the level of time precision for the timestamp | Seconds, Milliseconds, Microseconds | Yes | Default is Seconds |
Text of the converted datetime | If checked, the timestamp will be converted to text using the default format yyyy-MM-dd HH:mm:ss | - | No | If unchecked, returns a datetime object |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action produces a variable containing the converted datetime. Depending on whether the "Text of the converted datetime" option is checked, the output will be either a text string in the format "yyyy-MM-dd HH:mm:ss" or a datetime object.
Using Variables in Conditions
You can use the {x} notation to insert variables into the Timestamp parameter. This allows you to dynamically convert timestamps that were obtained from previous actions in your workflow.
Notes
Ensure the timestamp value is in the correct format based on the selected time granularity:
Seconds: Unix timestamp representing seconds since January 1, 1970
Milliseconds: Timestamp with millisecond precision (1000 times larger than seconds)
Microseconds: Timestamp with microsecond precision (1000000 times larger than seconds)
Invalid timestamp values will result in an error
The default text format for the converted datetime is "yyyy-MM-dd HH:mm:ss"