000034688 - Error ORA-01830: date format picture ends before converting entire input string when collecting a datetime object in RSA Identity Management and Governance

Document created by RSA Customer Support Employee on Jan 16, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034688
Applies ToRSA Product Set: Identity Management and Governance
RSA Version/Condition: 6.9.1, 7.0.0
 
IssueWhen 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).
CauseThis 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

 

Attachments

    Outcomes