Error ORA-01830: date format picture ends before converting entire input string when collecting a datetime object in RSA Identity Management and Governance
4 years ago
Originally Published: 2017-01-13
Article Number
000040259
Applies To
RSA Product Set: Identity Management and Governance
RSA Version/Condition: 6.9.1, 7.0.0
 
Issue
When collecting a datetime object, you may get the the following error on one or more rows.
 
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
This is caused by a difference in the way that datetime objects are handled between Oracle and other database systems. When selecting a datetime column, be sure to use the DATE_FORMAT function to ensure correct datetime formatting.

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

Trending Articles

Don't see what you're looking for?