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
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;
