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

Document ID:  TEC1771796
Last Modified Date:  08/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Identity Manager

Releases

  • CA Identity Manager:Release:14.0
  • CA Identity Manager:Release:12.6.8
  • CA Identity Manager:Release:12.6.7
  • CA Identity Manager:Release:12.6.6
  • CA Identity Manager:Release:12.6.5
  • CA Identity Manager:Release:12.6.4
  • CA Identity Manager:Release:12.6.3

Components

  • IdentityMinder(Identity Manager):IDMGR
Question:

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

Answer:

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:

preferencesDB.png

 

After this change has been made, the SQL DB columns should look similar as seen below:

datetimedb.png

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >