Description
Getting error message: invalid date format, when creating account on an Oracle DYN Namespace (created via Connector Express)
Need to know how to format a date for the Connector Express so that it can be inserted into an Oracle database.
Solution
Workaround: JCS expects date to be in the xml format yyyy-MM-ddThh:mm:ss. To get this format, we can simply change etaslapd's locale to match it:
- Logon to windows as etaslapd, and goto Control Panel -> Regional and Language Options. Under "Regional Options" tab, click on customize to change Short date format to yyyy-MM-dd. Make sure date separator is '-' and not '/'.
- In the policy, we still have to make some changes to add the time value. Change %D% to %D%T00:00:00. This means, the current date at zero hour (GMT).
- Restart provisioning and superagent services for changes to take effect.