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
RSA Governance & Lifecycle Tips & Tricks: Business Friendly Date Formats in Workflows/Emails Number of Views ORA-01840: Input value not long enough for date format error while setting the date type attribute filter in the review in… Number of Views Error: Cannot connect to database. 'Access denied. The database cannot be accessed at this time. RSA ACE/Server database a… Number of Views How to change the default Oracle Statistics History Retention period for RSA Identity Governance & Lifecycle Number of Views A successful RSA Cloud Authentication Service OIDC authentication is rejected by the application due to id_token missing r… Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA-2026-07: RSA Identity Router Security Update for Third-Party Component Vulnerabilities Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
