Article Content
Article Number | 000033456 |
Applies To | RSA Product Set: RSA Via Lifecycle and Governance (RSA Via L&G) RSA Version/Condition: 6.9.1 and higher |
Issue | When a date is entered into a control_type Date Field on a Request Form, the form converts the date to a number that is the passed on to workflows. For example, take a simple form with just one date field:
|
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:
to_date('${jobUserData_PublicData_Regina_Date_Number_StartDate}'/1000/60/60/24 + to_date('01-JAN-1970','DD-MON-YYYY')) AS StartDate
SELECT to_date('1467324960000'/1000/60/60/24 + to_date('01-JAN-1970','DD-MON-YYYY')) AS StartDate FROM dual; |