search cancel

How to make Oracle Database show created_time and last_access_time in the tasksession12_5 table for CA Identity Manager


Article ID: 15484


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On


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).


Release: CAIDMB99000-12.6.7-Identity Manager-B to B


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


1558718119453000015484_sktwi1f5rjvs16uta.png get_app
1558718117186000015484_sktwi1f5rjvs16ut9.png get_app