Article Content
Article Number | 000034688 |
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 |