ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Session start/end time only displaying date


Article ID: 212949


Updated On:


Clarity PPM On Premise


We are auditing user sessions. We found some information in the database tables: cmn_sessions and cmn_session_audits; however, we still could not find user session start time and end time. All this shows is Date. We are more interested in specific time.


Release : 15.8.1



By default the timestamp is saved in the database. It's possible that the tool being used to query may have a configuration issue.

If you are using SQL Developer, for example, look in the following settings to ensure the date is included in the format:

Tools > Preferences > Database > NLS Parameter

If further assistance is required, you may want to consult with a DBA to review.

Additional Information

More information on the session tables is located here: