How to convert the date field number from a request form to a human readable date in RSA Via Lifecycle and Governance
Originally Published: 2016-06-30
Last Modified: 2023-10-06
Article Number
Applies To
RSA Version/Condition: 6.9.1 and higher
Issue
For example, take a simple form with just one date field:
- On the next page, click Finish.
- A new request is generated.
- Find the request under Requests > Requests.
- Click on the Name of the request and pull it up.
- Click on the Processing Workflow of that request, and edit it.
- Right click anywhere outside a workflow node and select Properties.
- Click on the Runtime Data tab.
- Note that the start date variable is stored as 146732496000 and not 6/30/2016, as shown here:
Resolution
This format represents epoch time, that is milliseconds since 1 January 1970. The number can be converted back to a traditional date format with one of these constructs:
- In a SQL node you could use the variable:
to_date('${jobUserData_PublicData_Regina_Date_Number_StartDate}'/1000/60/60/24 + to_date('01-JAN-1970','DD-MON-YYYY')) AS StartDate
- Or in SQL*Plus you could:
SELECT to_date('1467324960000'/1000/60/60/24 + to_date('01-JAN-1970','DD-MON-YYYY')) AS StartDate FROM dual;
Related Articles
Zendesk for Sales - SAML Relying Party Configuration – RSA Ready Implementation Guide 3Number of Views Zendesk for Sales - RSA Ready Implementation Guide 7Number of Views 'Number of Missing Required Entitlements' under Role Analytics is not updated after completing Change Requests that succes… 65Number of Views A large number of user sessions showing on the UI in SecurID Governance & Lifecycle 193Number of Views 'UT000047: The number of parameters exceeded the maximum of 1000' error when adding User Attributes in RSA Identity Govern… 187Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process
Don't see what you're looking for?