How do you change the created_time and last_access_time columns to display the date and time for the tasksession12_5 table in CA Identity Manager? Oracle Database displays the columns only in DATE format by default Example YY-MM-DD (Year-Month-Day).
In Oracle Database, this can be changed this in preferences:
1. From Oracle SQL Developer's menu go to: Tools > Preferences.
2. From the Preferences dialog, select Database > NLS from the left panel.
3. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field.
4. Save and close the dialog, done!
Here is a screenshot:
<Please see attached file for image>
src="/servlet/servlet.FileDownload?file=0150c000004AKlGAAW" alt="preferencesDB.png" width="700" height="527">
After this change has been made, the SQL DB columns should look similar as seen below:
<Please see attached file for image>
src="/servlet/servlet.FileDownload?file=0150c000004AKlFAAW" alt="datetimedb.png" width="272" height="362">