Error ORA-01830: date format picture ends before converting entire input string when collecting a datetime object in RSA Identity Management and Governance
Originally Published: 2017-01-13
Article Number
Applies To
RSA Version/Condition: 6.9.1, 7.0.0
Issue
ORA-01830: date format picture ends before converting entire input string
This happens most often when the source is a non-Oracle database (e. g., Microsoft SQL Server).
Cause
To find the current datetime format in Oracle, use the following query:
SELECT * FROM T_SYSTEM_SETTINGS WHERE parameter ='DatabaseDateFormat'
You can convert to a proper datetime format using code similar to the following:
TO_CHAR(my_date_object, 'DD-MON-YYYY HH24:MI:SS') AS my_date_object
Related Articles
How to obtain the RSA Identity Governance & Lifecycle Application Last Modified Date, Creation Date and ID (Version) Number of Views Users migrated from RSA Authentication Manager 7.1 cannot request replacement tokens via the self service console after mi… Number of Views After upgrading to 8.0.0, migrated AFX Connectors show as "Not Deployed" in RSA Governance & Lifecycle Number of Views RSA Authentication Manager 8.1 replica attachment fails with error with migrated primary Number of Views How to change the default Oracle Statistics History Retention period for RSA Identity Governance & Lifecycle Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Downloading RSA Authentication Manager license files or RSA Software token seed records RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
